擅长:python、mysql、java
<p><strong>谢谢你的</strong>@schillingt</p>
<blockquote>
<p>updating for his answer, Actually when i search by the related_name for the model, the query filters the times of its existence in the other BookedDates model regardless to the date_from query in that model ...
So,
I made the query through the ManyToManyField itself to count times of thay bookedDates field only</p>
</blockquote>
<pre><code>roomsByDate = RoomType.objects.annotate(
modulo=numAdult % F('room_capacity')
).filter(
q_city, q_room_capacity1, modulo=0
).annotate(
times_booked=Count("bookedDates ", filter=Q(booked_from__in=day), distinct=True)
).exclude(
number_of_rooms__lte=F('times_booked')
)
</code></pre>