https://docs.djangoproject.com/en/3.1/ref/models/querysets/#range
[image: image.png] El vie, 19 mar 2021 a las 15:12, Manuel Buri (<[email protected]>) escribió: > 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: [email protected] > W: www.manuelburi.com <http://manuelburi.com/?utm_source=gmail> > > > On Fri, 19 Mar 2021 at 22:07, Anornymous u <[email protected]> wrote: > >> I mean what you want to fetch and the conditions >> >> On Fri, Mar 19, 2021, 16:01 Manuel Buri <[email protected]> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/76f85c72-19f9-4ad3-a39b-01dc60aa6da5n%40googlegroups.com >>> <https://groups.google.com/d/msgid/django-users/76f85c72-19f9-4ad3-a39b-01dc60aa6da5n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> 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 >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CAMXTB%3DcsfYRqGPbhXncaHNTjKqVhgskST8BDEAY-2fYonemfdg%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAMXTB%3DcsfYRqGPbhXncaHNTjKqVhgskST8BDEAY-2fYonemfdg%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CACx7KOQEEWWNu6hQwMXdEP_nZ6%2Bex9HZ9KEiVubrvd89%3DTP%3DuQ%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CACx7KOQEEWWNu6hQwMXdEP_nZ6%2Bex9HZ9KEiVubrvd89%3DTP%3DuQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- Héctor Alonso Lozada Echezuría -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADTS2YwcFMFPwWV_gRwW6Tj-BWGL%2B8%3D1SzQcVMM%2B5XcgcwGs%3DA%40mail.gmail.com.
