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%2B2LtkC9Qsf3oxm5bRLsL%2BECUtDqB_e2ycGnesB69zWkVoNhWg%40mail.gmail.com.
