SELECT *
FROM table_name
WHERE table_name.`name_of_column_that_contain_date` >= CURDATE()
This will show only rows starting from current day.
If you're not using queries, you can also filter the table with Conditional formatting for that column where the %TODAY% placeholder is available. You have to set a rule (attachment 1) that defines the data is less than %TODAY% , and set row class for example "hide" (like in example).
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables (attachment 2).
I was able to provide a work-around for the only possible option - current day, since You specified You were looking to add a value in the filter dialog for one of the following:
Current day
Current Week
Current Month
Current Quarter
Current year
Unfortunately, %THIS_MONTH% placeholder cannot link to <, = or > values under "Conditional Formatting", so it is not possible to add a custom CSS class for anything else other than %TODAY%. The %THIS_MONTH" placeholder can hide current month, but it is unable to display only the current month.
The way You can do this is to continue where You tried adding "Predefined value" and to set it to be the first day of current month, but to do that with every new month.
Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
Hi
I LOVE your product, it has changed the way I use WordPress.
I have a site where the data in the tables is growing quite fast, I would like to be able to add a value in the filter dialog for one of the following
Current day
Current Week
Current Month
Current Quarter
Current year
Please see attached example
Thank you for your consideration!
Grant
Hello GrantJoyce008,
Thank you for your purchase.
You can achieve this with SQL query like this
This will show only rows starting from current day.
If you're not using queries, you can also filter the table with Conditional formatting for that column where the %TODAY% placeholder is available. You have to set a rule (attachment 1) that defines the data is less than %TODAY% , and set row class for example "hide" (like in example).
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables (attachment 2).
This will show only data starting from current day.
Please let me know if this helps.
Best regards.
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
Hi I am not using SQL, its a manual table that users are adding to in WPDATATABLEL
is there a %currentmonth% place holder as this is the one i need urgently.
Thank You
Hello GrantJoyce008.
I was able to provide a work-around for the only possible option - current day, since You specified You were looking to add a value in the filter dialog for one of the following:
Current day
Current Week
Current Month
Current Quarter
Current year
Unfortunately, %THIS_MONTH% placeholder cannot link to <, = or > values under "Conditional Formatting", so it is not possible to add a custom CSS class for anything else other than %TODAY%. The %THIS_MONTH" placeholder can hide current month, but it is unable to display only the current month.
The way You can do this is to continue where You tried adding "Predefined value" and to set it to be the first day of current month, but to do that with every new month.
Best regards.
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
Thank you for your help
Please could you forward this as a development request as it is really needed.
Regards
Grant
Of course Grant,
Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
Best regards.
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