Re: 2 Almost equal Context with non-empty query set: 1 works, 1 returns nothing

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 <arisophy@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.buri@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+unsubscribe@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.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2B2LtkBe_Cc6xftuMMrQFUXzLMtWoDoimmhB1d%2BLBrpczANYKw%40mail.gmail.com.