CODEWITHSUNDEEP
pythonsqldjangodjango-queryset
user2047873
user2047873

Reputation: 63

Django Query writing

How to write below SQL query in form of Django Query

SELECT time 
FROM dispatcher_booking_timeline 
WHERE status = "completed" AND bookingId_id =
    (SELECT bookingId_id 
     FROM dispatcher_dispatch
     WHERE status = 0)

Thanks in advance.

Upvotes: 0

Views: 126

Answers (2)

CoRy
CoRy

Reputation: 41

And than should be 

booking_timelines = BookingTimeline.objects.filter(status="completed",pk__in=status_zeros)
times_set = set( booking_timelines.values_list('time', flat=True) )

Upvotes: 0

Henrik Andersson
Henrik Andersson

Reputation: 47172

Assuming you have models that maps 1-1 with your SQL query:

status_zeros = Dispatch.objects.filter(status=0).values_list('pk', flat=True)
BookingTimeline.objects.filter(status="completed", pk__in=status_zeros)

Upvotes: 1

Related Questions