Q model and or query giving incorrect result

Question

I want perform below SQL query using Q models

SELECT * FROM motor_vehicle_collision.collision_data_collisiondetails where (numberOfCyclistInjured > 0 or numberOfCyclistKilled > 0) and (longitude != '' and latitude != '');

for that I have written below query

   query = Q(numberOfCyclistInjured__gt=0)
    query.add(Q(numberOfCyclistKilled__gt=0), Q.OR)
    query.add(~Q(latitude=''), Q.AND)
    query.add(~Q(longitude=''), Q.AND)

but still I am getting data having latitude/longitude empty, how should I rectify it?

score 0 · Accepted Answer · answered Mar 18 '21 at 16:07

0

You can work with:

query = (Q(numberOfCyclistInjured__gt=0) | Q(numberOfCyclistKilled__gt=0))
    & ~Q(longitude='')
    & ~Q(latitude=''))

This makes it also more explicit how you bind the conditions together.

answered Mar 18 '21 at 16:07

Willem Van Onsem

443,496
30
428
555

I think there should be bracket before ~Q(longitude='') ? – LowCool Mar 18 '21 at 16:11
@LowCool: normally not, since `~` takes precedence over `&`. – Willem Van Onsem Mar 18 '21 at 16:14

Q model and or query giving incorrect result

1 Answers1