Q objects in django queryset

Question

g = Goal.objects.filter(Q(title__contains=term) | Q(desc__contains=term))

How can I add to my filter that user=request.user?

This doesn't work:

g = Goal.objects.filter(user=request.user, Q(title__contains=term) | Q(desc__contains=term))

Models:

class Goal(models.Model):
    user = models.ForeignKey(User)
    title = models.CharField(max_length=255)
    desc = models.TextField()

Don't just say, "this doesn't work", please include the traceback. In this case, the traceback is SyntaxError: non-keyword arg after keyword arg, which explains exactly what is going on. — Alasdair
– Alasdair, Commented Jan 17, 2014 at 15:03

Alasdair · Accepted Answer · 2014-01-17 15:01:30Z

12

Keyword arguments (user=request.user) must come after non keyword arguments (your Q object).

Either switch the order in your filter:

Goal.objects.filter(Q(title__contains=term) | Q(desc__contains=term), user=request.user)

or chain two filter() calls together

Goal.objects.filter(user=request.user).filter(Q(title__contains=term) | Q(desc__contains=term))

answered Jan 17, 2014 at 15:01

Alasdair

310k59 gold badges605 silver badges534 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yogesh dwivedi Geitpl · Accepted Answer · 2014-01-17 15:08:15Z

1

g = Goal.objects.filter(Q(user__iexact=request.user) & Q(title__contains=term) | Q(desc__contains=term))

Use & in place of Python and operator

answered Jan 17, 2014 at 15:08

Yogesh dwivedi Geitpl

4,4622 gold badges22 silver badges34 bronze badges

Comments

Premkumar chalmeti · Accepted Answer · 2017-11-23 06:39:19Z

1

According to django docs.

Lookup functions can mix the use of Q objects and keyword arguments. However, if a Q object is provided, it must precede the definition of any keyword arguments.

answered Nov 23, 2017 at 6:39

Premkumar chalmeti

1,0381 gold badge11 silver badges25 bronze badges

Collectives™ on Stack Overflow

Q objects in django queryset

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related