Hi I'm a newbie to Django. I'm trying to implement a search feature like 
this.

query_results = Shops.objects.filter\
                            (Q(shop_name__icontains=search_text)\
                            |Q(state__state_name__icontains=search_text)\
                            
|Q(city__city_name__icontains=search_text)).distinct()

I would like to search Shops based on the shop_name, state_name and 
city_name. State and city fields are foreign keys. For some 'Shops' stateand
city are null. However, shop_name contains the search_text. So I'm not 
getting those 'Shops' by running this query. Any help on this is 
appreciated.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/0c156715-b2fb-46ab-ad3d-d25235e7c4ca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to