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.