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 [email protected].
To post to this group, send email to [email protected].
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