2024-06-14 14:58:53 发布
网友
如何以Django查询的形式编写下面的SQL查询
SELECT time FROM dispatcher_booking_timeline WHERE status = "completed" AND bookingId_id = (SELECT bookingId_id FROM dispatcher_dispatch WHERE status = 0)
提前谢谢。你知道吗
假设您有与SQL查询1-1对应的模型:
status_zeros = Dispatch.objects.filter(status=0).values_list('pk', flat=True) BookingTimeline.objects.filter(status="completed", pk__in=status_zeros)
而不是应该的
booking_timelines = BookingTimeline.objects.filter(status="completed",pk__in=status_zeros) times_set = set( booking_timelines.values_list('time', flat=True) )
假设您有与SQL查询1-1对应的模型:
而不是应该的
相关问题 更多 >
编程相关推荐