I need to use a condition (where clause) in data table but I need dynamic constraint. For eg I need delivery_date > Datenow() (current date). How do I go about that?
Hello @AD,
I can advise you to use the On Before Mount handler of the Data Table component
instead of the Where Clause handler to avoid looping when current date is updated.
Regards,
Olha
I am able to get it working. Thanks. BUT seems like at every step, I need external help. For eg. where in the UI, I can find this ‘whereClause’.? Where are these listed?
I need to filter the data table content with where delivery_date > ‘currentdate’/Date Now.
The date column in database is set to DATETIME. Can you please help figure out why it’s not working? I see no errors.
This is working with other columns (such as acct_no etc) so I believe the issue is with formatting of the date .
Hello @AD
Could you please create a simple demo page in your app with the table component and logic you add?
If you can, please provide us with your app ID and the ui-builder page name so we can play around with it.
Regards