I want to search from database and return objects in order (soft_name,
category and subcategory are fields of a model)
            1st if soft_name has query
            then if category has query
            and then if subcategory has query

I've written this:

query = request.GET.get('q','')
if query:
 qset = (
Q(soft_name__icontains=query) |
 Q(category__icontains=query) |
 Q(subcategory__icontains=query) |
)
 results = Software.objects.filter(qset).distinct()

But this returns mixed results (not in required order)

Is it possible to obtain results in order without writing 3 queries and
joining the resultant lists?

Thanks
Akshit

-- 
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.

Reply via email to