On Mon, 2011-05-02 at 21:40 -0700, pankaj sharma wrote: > hello all, > i am trying to have an advanced search.. > i have college list where there are many tables in college like > college.name, collge.city college.state etc. > > so i have taken two strings from the user like Q1 and Q2. > now i want to show all the colleges which have Q1 string in name and > Q2 string in city.. > basically i want to add "and" & "or" statement in this statement : > > > college_list = College.objects.filter(name__icontains=Q1) > > > so i want to add one another filter like (city__icontains=Q2) >
You didn't really specified do you want AND query or OR query. And query is simple: college_list = College.objects.filter(name__icontains=Q1, city__icontains=Q2) Or query is sligthly different but not much, you need to use Q-objects for that (they're very powerful beings, you should read about them in the docs.) college_list = College.objects.filter((Q(name__icontains=Q1) | Q(city__icontains=Q2)) Hope that helps. -- Jani Tiainen -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
