Django ORM Filter By Checking Both column contains same values

Question

I have a model contains 3 column as follows:

Id NoOfL2 Open Delete Inprogress
1    2      1     1      0
2    4      1     2      1
3    3      3     0      0

I want to fetch all rows contains NoOfL2 == Open.

How should I found it using Django ORM?

Answer 1

You should use F expressions:

Foo.objects.filter(NoOfL2=F('Open'))