You can split your query set in two. First search elements with both
elements then elements with only one.
Obviously, that's two request, so there might be better way to handle the
problem.
On 20 Feb 2017 4:33 p.m., "Carlo Ascani" <carlo.r...@gmail.com> wrote:
> Hi all,
> I am just trying to add a search funcionality to my frontend.
> I know it is a huge topic, so sorry my n00bih questions.
>
> I have a model A
>
> class A(models.Model):
> roles = models.ManyToManyField(B)
> location = models.ForeignKey(C)
> ...
>
>
> These 2 fields are the only fields I care about
> when searching, so I would say I need a very
> specific field based search funcionality.
>
> I wrote this view to handle it
>
>
> class ASearch(ListView):
> model = A
> template_name = 'search_result.html'
>
> def get_context_data(self, **kwargs):
> context = super(A, self).get_context_data(**kwargs)
> results = A.objects.all()
> query = self.request.GET.get('q')
>
> if query:
> query_list = query.split()
>
> results = results.filter(
> reduce(operator.or_, (
> Q(roles__name__icontains=q)
> for q in query_list)) |
> reduce(operator.or_, (
> Q(location__name__iexact=q)
> for q in query_list))
> )
>
> context.update({
> 'results': results
> })
> return context
>
>
>
> This is quite working. I mean, results are fine.
> But the problem is that I would like that searches
> who covers *all* conditions to come first.
>
> For example, let's say I search for 'MyRole MyLocation'
> the results I get are all the As for MyRole and all the
> As for MyLocation, mixed.
>
> I would like that As with MyRole AND MyLocation to show
> up first.
>
>
> I hope I was clear enough, but I doubt it.
>
> Thank you in advance
>
> --
> 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 django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/django-users/2c34b391-95d3-4ae9-acb1-81649833a725%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/2c34b391-95d3-4ae9-acb1-81649833a725%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
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 django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAEuG%2BTb_wx0YLZyx%2B7Ax1v7%2BsczrtZfCPYVFbcicQ2t7PhrK_w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
