Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I have been looking for a workaround for some time, but despite best efforts still not able to confirm if we can do this.
I have to escalate this to our 2nd level Team, and possibly to the developers, just to be sure to give you accurate information.
As soon as I check everything with them, i will come back to you straight away with confirmation, and i am hoping with a solution. Thank you for your patience.
I haven't had a chance to incorporate this, as I've been busy (and finally, successfully) building a 1.2m record dataset and running it via wpDataTables
If you can, would you mind explaining why there is no formatting option on the two date fields that I've imported?
They are currently correctly displaying as dd/mm/yyyy but there is no option to change Date Input format or otherwise change the display style.
All dates inherit the format from wpDataTables General Settings. The imported format needs to be the same in order for wpDataTables to pick up the correct dates and import them. This is how the plugin currently works, and our developers haven't had the chance to adjust DataTables' logic in order for you to choose the import format.
We hope they'll be able to do this soon, but we can't make any promises.
I'd like to change the global search block from %LIKE% (LIKE?) to = (equals)
Is this possible, please?
Hi, Brian
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I have been looking for a workaround for some time, but despite best efforts still not able to confirm if we can do this.
I have to escalate this to our 2nd level Team, and possibly to the developers, just to be sure to give you accurate information.
As soon as I check everything with them, i will come back to you straight away with confirmation, and i am hoping with a solution.
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
Hello , Brian
I believe we have what you need, sorry that you've waited so long.
Can you please try with this filter?
wpdatatables_filter_mysql_query( $query, $tableId )
It is applied to the MySQL query before it is sent to the MySQL server.
$query is the query text
$tableId is the table identifier from the MySQL table (wp_wpdatatables).
-
Let me know how it goes and if you need any assistance. Thanks.
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 Miloš
I haven't had a chance to incorporate this, as I've been busy (and finally, successfully) building a 1.2m record dataset and running it via wpDataTables
If you can, would you mind explaining why there is no formatting option on the two date fields that I've imported?
They are currently correctly displaying as dd/mm/yyyy but there is no option to change Date Input format or otherwise change the display style.
Thanks
Brian
Hello Brian
Sorry for the late response.
All dates inherit the format from wpDataTables General Settings. The imported format needs to be the same in order for wpDataTables to pick up the correct dates and import them. This is how the plugin currently works, and our developers haven't had the chance to adjust DataTables' logic in order for you to choose the import format.
We hope they'll be able to do this soon, but we can't make any promises.
Kind Regards,
Aleksandar Vuković
[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