I have been experimenting with the conditional filter, so that if a date in a cell is in the past (i.e. < %TODAY%), I can add a CSS class to that row, and make the row invisible by making that class "display: none;"
If I set the table to initially show All rows, this works fine.
But my table is large, so I need to set it to show 25 rows with pagination. Here is the full table with no filter:
I made a filter which says if Arrival < %TODAY%, set CSS class to 'gone' and do not display that class.
When I apply the filter, this gives pages where no rows show. If I paginate through them, I eventually reach "today", and the rows start to show again. Here is another table, showing what happens.
Unfortunately, there is no such a option with built in features of plugin, but you can set option Use as default sorting column on SORTING tab in column settings for that date column and set option Default sorting direction to Descending order.
Hi,
I have been experimenting with the conditional filter, so that if a date in a cell is in the past (i.e. < %TODAY%), I can add a CSS class to that row, and make the row invisible by making that class "display: none;"
If I set the table to initially show All rows, this works fine.
But my table is large, so I need to set it to show 25 rows with pagination. Here is the full table with no filter:
http://newzealandcruiseassociation.com/schedule/
I made a filter which says if Arrival < %TODAY%, set CSS class to 'gone' and do not display that class.
When I apply the filter, this gives pages where no rows show. If I paginate through them, I eventually reach "today", and the rows start to show again. Here is another table, showing what happens.
http://newzealandcruiseassociation.com/time-test/
If you go through the pagination, you will eventually reach the data from %TODAY% and afterwards (it's page 24)
Is there a way to have the data from %TODAY% and afterwards show when the table loads on the page, so I can keep the pagination of 25 rows?
Kind regards
Keith
HI Keith,
Thank you for your purchase.
Unfortunately, there is no such a option with built in features of plugin, but you can set option Use as default sorting column on SORTING tab in column settings for that date column and set option Default sorting direction to Descending order.
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