Comments 2Barry Horsley started the conversationDecember 21, 2021 at 3:32pmI would like to filter a table that has dates less than or equal to %TODAY%. Is this possible?Use case.... I would like to allow a user to upload attachments (job advertisements) with another field being an expiration date.When the public views the table, I want to filter out anything that has expired. 2Barry Horsley repliedDecember 21, 2021 at 10:34pmSo I ended up making a table that would be the parent tableThen I made an sql table that would query the parent table base on the Variable of %CURRENT_DATE%It would be simpler and cleaner if the filter default values allowed the use of a variable. If there is another way, let me know. 2,572Aleksandar repliedDecember 23, 2021 at 10:32amHello BarryI am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.The date filter can only be a date range, and unfortunately you can't include filters that are <, <, >, > than %TODAY%.I would also suggest using an SQL query to create a child table that would filter this and post that table on the front-end.Kind Regards, Aleksandar Vuković[email protected] Rate my support wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables Sign in to reply ...
I would like to filter a table that has dates less than or equal to %TODAY%.
Is this possible?
Use case....
I would like to allow a user to upload attachments (job advertisements) with another field being an expiration date.
When the public views the table, I want to filter out anything that has expired.
So I ended up making a table that would be the parent table
Then I made an sql table that would query the parent table base on the Variable of %CURRENT_DATE%
It would be simpler and cleaner if the filter default values allowed the use of a variable. If there is another way, let me know.
Hello Barry
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
The date filter can only be a date range, and unfortunately you can't include filters that are <, <, >, > than %TODAY%.
I would also suggest using an SQL query to create a child table that would filter this and post that table on the front-end.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables