Hi I have created several tables and different views to have reports according to my needs.
However I only have a table (https://crm.medicalverso.com/report-generale-televisite/) where it is possible to have filters by date.
Since the views of the data are aggregated based on queries that do not have a filter for dates or other fields, how can I make the user filter based on dates or other fields?
For example this table (https://crm.medicalverso.com/report-visite-specialita/) which is based on a view would be filterable by date fields?
Hi I have created several tables and different views to have reports according to my needs.
However I only have a table (https://crm.medicalverso.com/report-generale-televisite/) where it is possible to have filters by date.
Since the views of the data are aggregated based on queries that do not have a filter for dates or other fields, how can I make the user filter based on dates or other fields?
For example this table (https://crm.medicalverso.com/report-visite-specialita/) which is based on a view would be filterable by date fields?
Thanks Gianluca
Hi, Gianluca
Sorry for the delay.
-
I can see on table on this page https://crm.medicalverso.com/report-generale-televisite/
you have a date column, and the date filter is working on it.
-
If you create an SQL View, you can still pull date data from the data base, from date columns;
and you should be able to use the Date filter for our tables.
-
But, it seems i maybe didn't understand , i am not sure.
On this other table from page https://crm.medicalverso.com/report-visite-specialita ,
i can't see any date column in this table.
Could you please elaborate a bit more, i can't seem to fully understand your query?
Thank you
Kind Regards,
Miloš Jovanović
milos.jovanovic@tmsproducts.io
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