Can you share your "Booking" model and the view (function or class) that
renders the template?, and I beg you, please use pastebin.com for share
your code :D
El vie, 19 mar 2021 a las 16:17, Manuel Buri (<manuel.b...@gmail.com>)
escribió:
> @anornymou...@gmail.com and ima...@gmail.com
> your suggestion is unfortunately not working too
>
> @All:
> So as said my queryset is not empty, meaning that the query works.
> However, the results is not in the rendered HTML file.
> This would imply that with my template is something wrong, don't you think?
>
> {% for office in office.all %}
> <small>{{ office.office_name }}</small>
> {% for booking in bookings %}
> <div class="client-item">
> <div class="client-text">
> <p class="name">{{ booking.account.first_name }} {{
> booking.account.last_name }}</p>
> {% if booking.get_location_display == 'House' %}
> <p class="sub-title">🏢 {{ booking.get_location_display
> }}</p>
> {% elif booking.get_location_display == 'Home' %}
> <p class="sub-title">🏠 {{ booking.get_location_display
> }}</p>
> {% else %}
> <p class="sub-title">🤔 {{ booking.get_location_display
> }}</p>
> {% endif %}
> </div>
> </div>
> {% endfor %}
> {% endfor %}
>
>
> What do you think?
>
> 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 <http://manuelburi.com/?utm_source=gmail>
>
>
> On Fri, 19 Mar 2021 at 22:51, Thomas Lockhart <tlockhart1...@gmail.com>
> wrote:
>
>> 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 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/7C87F855-5ECE-4470-A8CA-916B64F7CFF5%40gmail.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/CACx7KOS-9b1UP%3D4t4jUOHgn8co_19W2CCRCQWR%3DCWwLHWR%2BsFQ%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CACx7KOS-9b1UP%3D4t4jUOHgn8co_19W2CCRCQWR%3DCWwLHWR%2BsFQ%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 django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CADTS2YzEw3jqctmHaWfhhZagmy0VW8-XvppHQtHTCAzmSf3v-Q%40mail.gmail.com.
