Django Filter Query Solution

Question

I need to filter null and blank fields for several attributes. So far the solution I have found that works is this one :

avaluos=Avaluo.objects.filter(Q(Estatus='CONCLUIDO',Pagado=False,Factura__isnull=True)
|Q(Estatus='CONCLUIDO',Factura__isnull=True,Pagado__isnull=True)
|Q(Estatus='CONCLUIDO',Factura__exact='',Pagado__isnull=True)
|Q(Estatus= 'CONCLUIDO',Factura__exact='',Pagado=False))

However I am pretty sure this is not the best option. Is there any more efficient way to do this?

ykaganovich · Accepted Answer · 2013-03-28 21:02:27Z

2

I think if you chain your clauses, it'll be more readable.

avaluos= ( Avaluo.objects
           .filter(Estatus='CONCLUIDO')
           .filter(Q(Factura='')|Q(Factura__isnull=True))
           .filter(Q(Pagado=False)|Q(Pagado__isnull=True)) )

answered Mar 28, 2013 at 21:02

ykaganovich

15.1k8 gold badges63 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

Django Filter Query Solution

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related