When you create a table linked to the CSV file, the structure of the table is saved in wp_wpdatatables and wp_wpdatatables_columns database tables. So, if the source file changes the table will update as well. Please note that if the structure changes (adds, removes, renames or rearranges column headers), the table created in wpDataTables will break.
You can add predefined filtering date range, but that would be a fixed range.
If you create a MySQL table, you can include the DATEDIFF function, so the whole table automatically displays records from the past x number of days.
im using the lite version of WPDataTables.
I created a cvs table - a tv show schedule for the month.
How can I have the schedule update (eg, every hour) and hide all previous days and even hours earlier in the day? either in lite or pro version?
thanks
Hi Sam
Thank you for reaching out to us.
When you create a table linked to the CSV file, the structure of the table is saved in wp_wpdatatables and wp_wpdatatables_columns database tables. So, if the source file changes the table will update as well. Please note that if the structure changes (adds, removes, renames or rearranges column headers), the table created in wpDataTables will break.
You can add predefined filtering date range, but that would be a fixed range.
If you create a MySQL table, you can include the DATEDIFF function, so the whole table automatically displays records from the past x number of days.