I’ve entered a start date and end date, and I want to fetch all employee details where the date falls between these two dates. I also want to group the results by email (mail ID) and aggregate the total_minutes for each employee. However, after selecting the start and end dates, no data is being displayed, even though the relevant data is already present in the Bubble database.
Can anyone help me figure out what might be causing this issue?
check privacy rules on the date fields, also check the status field exists or uses the quotation marks (also, I recommend removing quotation marks from status anyway)
But looking at all screen shots, it is likely not associated with dates or privacy rules, but the status as in the database it shows as Present with no quotation marks, but in your search constraint you use quotation marks.
Working after removing the quotation marks. Thanks!
This topic was automatically closed after 70 days. New replies are no longer allowed.
