Why use Q? afaict simple filter syntax should get you what you want. Booking.objects.filter(organization_id=request.user.organization_id, booking_time__range= (start_date, end_date))
Not sure if this will get you closer to the query you expect. You might also find it useful to use "./manage.py shell" to test the queries by hand. Import a few models, put in “11” for the organization_id, and see what happens. - Tom > On Mar 19, 2021, at 2:11 PM, Manuel Buri <manuel.b...@gmail.com> wrote: > > I want to fetch all bookings for the users organization_id between start_date > and end_date. > I am achieving this via this queryset, however, as soon as I add the second > filter (bold), it is not rendered in the template anymore and I, therefore, > do not see it in my HTML file. > context['bookings']=Booking.objects.filter( > Q(organization_id=request.user.organization_id), Q(booking_time__range= > (start_date, end_date))) > > Thank you so much for your help. > Best wishes, > > Manuel > > > > Manuel Buri > T: +41 79 933 01 11 > M: manuel.b...@gmail.com > W: www.manuelburi.com > > > On Fri, 19 Mar 2021 at 22:07, Anornymous u <anornymou...@gmail.com> wrote: > I mean what you want to fetch and the conditions > > On Fri, Mar 19, 2021, 16:01 Manuel Buri <manuel.b...@gmail.com> wrote: > Hi, > > I am having this query set in my view: > context['bookings']=Booking.objects.filter( > Q(organization_id=request.user.organization_id), Q(booking_time__range= > (start_date, end_date))) > > It produces a non-empty query set! > However, I am NOT able to display it in my template. > > If I get rid of Q(booking_time__range= (start_date, end_date) and only do: > context['bookings']=Booking.objects.filter( > Q(organization_id=request.user.organization_id)) > then it is also non-empty AND it is displaying it in my template. > > What am I missing here? > > Thank you for your help. > > Manuel > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/76f85c72-19f9-4ad3-a39b-01dc60aa6da5n%40googlegroups.com. > > -- > You received this message because you are subscribed to a topic in the Google > Groups "Django users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/django-users/2DC9EY75yuM/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAMXTB%3DcsfYRqGPbhXncaHNTjKqVhgskST8BDEAY-2fYonemfdg%40mail.gmail.com. > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CACx7KOQEEWWNu6hQwMXdEP_nZ6%2Bex9HZ9KEiVubrvd89%3DTP%3DuQ%40mail.gmail.com. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/7C87F855-5ECE-4470-A8CA-916B64F7CFF5%40gmail.com.
