Using database values in django queryset

Question

Basically what i'm trying to accomplish is a query like this but using QuerySet:

SELECT value1, value2 FROM table WHERE value1 > value2

How do i do this? Thanks for your help.

The Django documentation about queryset is pretty detailed. At which point are you stuck ? — Sylvain Leroux
– Sylvain Leroux, Commented Aug 26, 2014 at 15:38

johntellsall · Accepted Answer · 2014-08-26 15:39:03Z

1

Use F expressions to have a query field refer to another.

from django.db.models import F
Entry.objects.filter( n_comments__gt=F('n_pingbacks') )

answered Aug 26, 2014 at 15:39

johntellsall

15.2k4 gold badges48 silver badges40 bronze badges

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

Comments

Ania Warzecha · Accepted Answer · 2014-08-26 15:41:07Z

0

You need to use the F() expression

In your example it would look like:

from django.db.models import F
Table.objects.filter(value1__gt=F('value2')).values('value1', 'value2')

answered Aug 26, 2014 at 15:41

Ania Warzecha

1,81614 silver badges26 bronze badges