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 <ariso...@is-jpn.com>: > 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 <ariso...@is-jpn.com>: > >> 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 <manuel.b...@gmail.com>: >> >>> 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 django-users+unsubscr...@googlegroups.com. >>> 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 django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2B2LtkA3xDROCw7rH0cWubQ9Tq12nB0hVLASPPEtftbwADe0PQ%40mail.gmail.com.
