Django mysql query

Question

I am new to django and I have difficulty in constructing django query. Can anyone please help me to construct this query into django query?

SELECT DISTINCT mt.ID_Number 
FROM measurement_test mt 
WHERE mt.Start_Date IN('2012-02-15','2012-06-14') 
AND mt.ID_Number != ''

Reinbach · Accepted Answer · 2012-09-05 14:07:49Z

3

Assuming "measurement_test" is the object the models the relevant table.

measurement_test.objects.values_list(ID_Number).filter(Start_Date__in=('2012-02-15','2012-06-14')).exclude(ID_Number='').distinct()

answered Sep 5, 2012 at 14:07

Reinbach

7714 silver badges7 bronze badges

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

Comments

Vivek S · Accepted Answer · 2012-09-05 14:15:01Z

1

You can use the following,

measurement_test.objects.filter(~Q(ID_Number=''), Start_Date__in=['2012-02-15','2012-06-14']).values('ID_Number').distinct()

answered Sep 5, 2012 at 14:05

Vivek S

5,5708 gold badges57 silver badges74 bronze badges

This is not a valid Django query. You can't use != in filter calls.