I have a field that has a designated date for each row/entry. I would like to have only those entries show up whose dates are 3 days prior, or earlier, when compared to the Current Date (ie. At least 3 days old). Do I put this in the "add condition" feature on Create a Table or do I do this in a CSS in Conditional Formatting somewhere? I tried to understand previous tickets but could not follow fully. Also, wherever I enter, what is the proper format?
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
My suggestion is to use MySQL query logic for such functionality, because it is not possible to show entries in table whose dates are 3 days prior with existing placeholders in Conditional formatting.
When I said "use MySQL query logic" I mean that you need to make a query that will return data that you need using MySQL functions. You can take a look on this link where you can find one of the examples for returning data depends of some condition(get records that are more than 7 days old)There is a lot of examples on Internet especially on stackoverflow.com where you can find a lot of useful examples.
Please note that writing custom queries are out of scope that we provide with standard support. Support with such requests can be provided on a paid basis.
I have a field that has a designated date for each row/entry. I would like to have only those entries show up whose dates are 3 days prior, or earlier, when compared to the Current Date (ie. At least 3 days old). Do I put this in the "add condition" feature on Create a Table or do I do this in a CSS in Conditional Formatting somewhere? I tried to understand previous tickets but could not follow fully. Also, wherever I enter, what is the proper format?
Do I use %TODAY% or CURDATE()?
Thank you.
PS I am using the query of MySQL creation format.
Hi CopyrightSlap,
Thank you for your purchase.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
My suggestion is to use MySQL query logic for such functionality, because it is not possible to show entries in table whose dates are 3 days prior with existing placeholders in Conditional formatting.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank you. How do I "use MySQL query logic" to achieve this functionality?
Hi CopyrightSlap,
When I said "use MySQL query logic" I mean that you need to make a query that will return data that you need using MySQL functions. You can take a look on this link where you can find one of the examples for returning data depends of some condition(get records that are more than 7 days old)There is a lot of examples on Internet especially on stackoverflow.com where you can find a lot of useful examples.
Please note that writing custom queries are out of scope that we provide with standard support. Support with such requests can be provided on a paid basis.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables