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.