I linked the plugin with a SQL database. I have two problems:
1) For every columns is not possibile to select a Predefined value(s) in a selectbox filter, because the list remains empty. See screenshot n.1 for an example, you can see that the list empty, but the "prodotto" column is populated.
2) The data range filter doesn't work. On the SQL database the column is of type date, also on wpdatatable. You can observe the situation on screenshot n.2.
I am delighted to hear that this has been resolved. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets.
Goodmorning,
I linked the plugin with a SQL database. I have two problems:
1) For every columns is not possibile to select a Predefined value(s) in a selectbox filter, because the list remains empty. See screenshot n.1 for an example, you can see that the list empty, but the "prodotto" column is populated.
2) The data range filter doesn't work. On the SQL database the column is of type date, also on wpdatatable. You can observe the situation on screenshot n.2.
Is it possible to fix these problems?
Thank you very much
Attached files: 2.png
1.png
I solved the problem by creating a view in the database with exactly the columns I needed.
Hi, Franck
Thanks for reaching out to us
I am delighted to hear that this has been resolved. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets.
Have a great day!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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