As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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