Display only today data

[vaskoZGU]

Hello,

I use external MySQL DB.
I need help displaying data for today's date only.
Assuming today is 9 Nov 2022 (2022-11-09) my goal is to display only first 2 rows in table for the app users.

Thank you.

[ConorWebb96]

Hey @vaskoZGU,

From the looks of the above screenshot it seems to be the sample data provided via using the internal Budibase db, not an external MySQL DB.

Theres a few different ways you can achieve this. Are you wanting this to occur on load or are you wanting the users to be able to change this in the frontend? Below are a few quick examples showing how you can do this;

You can use the dynamic filter component and write the query within the frontend using it.
Componet tree

Output

Or you can filter directly on the Data provider

You can even use a date picker field to allow more control, instead of hardcoding the filter like the above you'd supply the form fields value as the value checked against.

I hope this makes sense and is helpful.

[vaskoZGU]

Hi @ConorWebb96,

Thank you for your reply.
Actually I use the sample data for testing, but the real backend is MariaDB.

Users add data daily via a form.
They should not see any data from the past in the table, only data added during the current day.
The next day they should start with an empty table (filtered).

If I create a filter in the data provider as in your last screenshot, the user will see the past data from 2022-11-01 (assuming today is 2022-11-09). Am I right?

[ConorWebb96]

Hey @vaskoZGU,

If you want only records of the current day I'd recommend adding the below JS inside that binding were that date is displayed in the last screenshot.

const currentDate = new Date();
currentDate.setHours(0, 0, 0, 0);

return currentDate;

This will always default it to the current date at 00:00, meaning your data will be filtered by dates on a specific day.

I hope this makes sense.

[vaskoZGU]

Thank you @ConorWebb96

This is what I was looking for.