We don't work on weekends so it adds two days to the waiting time.
we appreciate your patience.
-
In the filters, it is not possible to set an available filter that would only show rows with date only from today and in the future, or in other words something like "if greater than today show/ and hide the rest",
but i might have an idea how you might achieve a table displayed like that with our Conditional Formatting.
I was thinking, if we set a condition on a Date column to say "if the date is less than today, then add a CSS class to these rows as 'hide' " , which in theory should hide all the other rows that are "less than today's date",
but i am getting strange results on my Test site.
I tried this with my table, and i expected it will hide the other rows, it does hide them, but i have to go through these "empty table pages" for some reason, i think it might be a bug.
For example, i got this table, and if i set the sorting as "descending" to sort table by the Date column,
then it works fine - the latest dates go on top, and i can see the today's and future rows in Dates,
But if i go for "ascending order" of sorting table by order_Date, then it looks strange, a lot of empty pages of the table with hidden rows.
We will check this with our QA Team and i will report back as soon as we confirm this for you.
And i will also check if there might be any other workarounds, through an SQL Query or anything like that.
Thank you for your answer. I had the change to ask a friend regarding this question and he gave me this line in the query which works perfect for my case:
where wp_wpdatatable_#.datetime >= NOW()
Thanks again for your big support. We can close this ticket.
Hello! I want to filter my datetime column so that i only see rows/entries with datetime today or in future
I only see in the filtersettings the possibility for a date range (from ..to) but not a filter setting from today...
I tried to search on google for a sqr query but i had to give up. My knowledge is still limited here.
Thank you for your help
BR Andreas
Hi, Andreas.
Sorry for the waiting time.
We don't work on weekends so it adds two days to the waiting time.
we appreciate your patience.
-
In the filters, it is not possible to set an available filter that would only show rows with date only from today and in the future, or in other words something like "if greater than today show/ and hide the rest",
but i might have an idea how you might achieve a table displayed like that with our Conditional Formatting.
I was thinking, if we set a condition on a Date column to say "if the date is less than today, then add a CSS class to these rows as 'hide' " , which in theory should hide all the other rows that are "less than today's date",
but i am getting strange results on my Test site.
I tried this with my table, and i expected it will hide the other rows, it does hide them, but i have to go through these "empty table pages" for some reason, i think it might be a bug.
For example, i got this table, and if i set the sorting as "descending" to sort table by the Date column,
then it works fine - the latest dates go on top, and i can see the today's and future rows in Dates,
But if i go for "ascending order" of sorting table by order_Date, then it looks strange, a lot of empty pages of the table with hidden rows.
We will check this with our QA Team and i will report back as soon as we confirm this for you.
And i will also check if there might be any other workarounds, through an SQL Query or anything like that.
Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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 Milos!
Thank you for your answer. I had the change to ask a friend regarding this question and he gave me this line in the query which works perfect for my case:
where wp_wpdatatable_#.datetime >= NOW()
Thanks again for your big support. We can close this ticket.
BR Andreas
Hi, Andreas.
I was just getting an update from our QA Team,
they are working on a solution with Conditional Formatting for use-cases when we are not using SQL based tables/ when using non-server-side tables,
still working to get a perfect solution, but i can see that you have found a working solution for your use-case.
Thank you for sharing this with us, we will make a note of it for other users who need the same use-case with SQL tables, that is awesome.
We will close this ticket, and still going to work on finding an alternative option for non-server-side tables, via Conditional Formatting.
Thanks again, and of course, please don't hesitate to open new tickets if anything else comes up.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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