Issue with Fetching and Grouping Employee Data by Date Range in Bubble Database

jenil.kukadiya · 2024-10-10T11:31:38.807Z

image982×898 48.7 KB

image1059×918 53.4 KB

image1651×690 13 KB

image1554×602 59 KB

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?

jenil.kukadiya · 2024-10-10T12:10:23.328Z

@boston85719

boston85719 · 2024-10-10T15:41:05.412Z

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.

jenil.kukadiya · 2024-10-11T05:26:35.709Z

Working after removing the quotation marks. Thanks!

system · 2024-12-19T11:31:56.400Z

This topic was automatically closed after 70 days. New replies are no longer allowed.