thank you so much Arisophy. I am not able to fix the problem with your suggestions. Please be aware that I am not having any empty query sets while filtering etc. So it must be a problem with getting the context to HTML, however, it is super weird, because as long as I am not filtering for a date my HTML renders the context perfectly.
Does that help to provide further help? Thank you so much. Manuel On Friday, 19 March 2021 at 04:09:54 UTC+1 [email protected] wrote: > use this > > https://docs.djangoproject.com/ja/3.1/ref/models/querysets/#date > > *.filter(booking_time__date=booking_date) * > > > 2021年3月19日(金) 11:58 Arisophy <[email protected]>: > >> Hi Manuel >> >> Oops! >> *.filter(booking_time=booking_date) doesn't work* >> >> Did you check the query and DB data? >> Are booking_time's time of DB data just 00:00:00? >> >> If another time, you have to use >> booking_time >= target_date AND booking_time < next_date_of_target >> >> Arisophy >> >> 2021年3月19日(金) 9:36 Arisophy <[email protected]>: >> >>> Hi, Manuei >>> >>> I think , >>> At first, you shoukd check the value of "request.user.organization_id" . >>> Next, try to use Q if the value is valid. >>> >>> context['bookings'] = >>> Booking.objects.filters(Q((organization_id=request.user.organization_id) & >>> Q(booking_time=booking_date)) >>> >>> >>> https://docs.djangoproject.com/en/3.1/topics/db/queries/#complex-lookups-with-q >>> >>> regards >>> >>> Arisophy >>> >>> 2021年3月19日(金) 7:59 Manuel Buri <[email protected]>: >>> >>>> Hi folks, >>>> can you please help me with this. >>>> >>>> I am trying to get the context working where I filter for the >>>> organization_id as well as the booking_time. Both queries are not empty, >>>> however, only the context without the booking_time filter works while >>>> rending in html. >>>> >>>> Code: >>>> @login_required >>>> def overview_view(request): >>>> >>>> context = {} >>>> booking_date = None >>>> >>>> if request.method == 'GET': >>>> if request.is_ajax(): >>>> booking_time = request.GET.get('day') >>>> booking_time = datetime.strptime(booking_time, "%Y-%m-%d") >>>> booking_date = booking_time.replace(hour=0, minute=0, second=0, >>>> microsecond=0, tzinfo=pytz.utc) >>>> >>>> *THIS ONE DOES NOT WORK* >>>> >>>> *context['bookings'] = >>>> Booking.objects.filter(organization_id=request.user.organization_id).filter( >>>> >>>> booking_time=booking_date)* >>>> >>>> *THESE DO WORK:* context['bookings'] = >>>> Booking.objects.filter(organization_id=request.user.organization_id) >>>> return render(request, 'overview/overview.html', context) >>>> >>>> return render(request, 'overview/overview.html', context) >>>> >>>> >>>> Thank you so much 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/8afb07f4-10b2-4145-ab23-6fe9bb41c599n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/django-users/8afb07f4-10b2-4145-ab23-6fe9bb41c599n%40googlegroups.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/25e1bce8-7c13-4673-891c-ea170bcf4f85n%40googlegroups.com.
