Filter queryset by checking two columns if they are equal

user_18724853 0
Viewed 102

models.py

class Entry(models.Model):
    paid = models.FloatField(blank=True, null=True)
    price = models.FloatField(blank=True, null=True)

I want to get all entries that have paid and price columns the same value. How can I achieve this?

django python
2 Answers

I found a solution for this

from django.db.models import F

Entry.objects.filter(price=F('paid'))
user_187248530 
x = 12
Entry.objects.get(paid=x, price=x)

Does this solve your problem??

user_107572640
Related