I have a database that contains a date field. Would it be possible to only display the data from that database where the date field is after todays current date? In other words display all content whose date is in the future. Likewise I then need a separate table of the same data displaying the data from all dates that are in the past. (A sort of archive system.)
Correct me if I am wrong, you want to hide all rows that contain date that is in the past compared euth the current date? If that is true you can use Conditional formatting and placeholder TODAY.
When you set that If cell value is less than current date(%TODAY% placeholder) then Set row CSS class for example hide_rows.(attachment 1)
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables like this(attachment 2):
That is exactly what I was asking for. I will now be able to create two tables one showing all data that is "old" (past today's date) and one showing "new" data showing all data that is still yet to arrive.
On a similar subject, my client would also like to show when new data has been added to the table. Is there any way to in effect show a row colour for 7 days to indicate that any new item added to the table is shown as "New" for 7 days. My thoughts are along the lines of setting up two rules, one to start the period using %TODAY% and the second to end the period using %TODAY% + 7 .
After the update now on new version the do not allow duplicate values option is missing. It was nice on older version I had used that option so people do not end up creating duplicate records but in new version I am unable to do that and people are end up creating duplicate values which is causing a huge problem
Unfortunately at the moment there’s no built-in solution. However it appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side for one of next versions.
Hi Josh,
Can you please open a new ticket and we help you because the issues are different and we want to keep one issue related with the title of the ticket, so other customers can find it easily and also for every new post it will be sent notification to the customer who open this ticket that is not appropriate.
Dear Sirs,
I have a database that contains a date field. Would it be possible to only display the data from that database where the date field is after todays current date? In other words display all content whose date is in the future. Likewise I then need a separate table of the same data displaying the data from all dates that are in the past. (A sort of archive system.)
Thank you for your patience with me.
Kind regards,
Ian
Hi Ian,
Thank you for your purchase.
Correct me if I am wrong, you want to hide all rows that contain date that is in the past compared euth the current date? If that is true you can use Conditional formatting and placeholder TODAY.
When you set that If cell value is less than current date(%TODAY% placeholder) then Set row CSS class for example hide_rows.(attachment 1)
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables like this(attachment 2):
.hide_rows{ display:none !important; }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
Milan,
That is exactly what I was asking for. I will now be able to create two tables one showing all data that is "old" (past today's date) and one showing "new" data showing all data that is still yet to arrive.
On a similar subject, my client would also like to show when new data has been added to the table. Is there any way to in effect show a row colour for 7 days to indicate that any new item added to the table is shown as "New" for 7 days. My thoughts are along the lines of setting up two rules, one to start the period using %TODAY% and the second to end the period using %TODAY% + 7 .
Is this possible?
Kind regards,
Ian
After the update now on new version the do not allow duplicate values option is missing. It was nice on older version I had used that option so people do not end up creating duplicate records but in new version I am unable to do that and people are end up creating duplicate values which is causing a huge problem
Hi Ian,
Unfortunately at the moment there’s no built-in solution. However it appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side for one of next versions.
Hi Josh,
Can you please open a new ticket and we help you because the issues are different and we want to keep one issue related with the title of the ticket, so other customers can find it easily and also for every new post it will be sent notification to the customer who open this ticket that is not appropriate.
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