I need information before purchasing another license.
I used wpdatatables_before_get_table_metadata to set a range of dynamic variable dates in a page: $ wdtVar1 and $ wdtVar2 which I then used with "between"% VAR1% "AND"% VAR2% "in the sql query
All perfect :) but...
For a new project, I would need additional variables to filter the result also on the third and fourth fields (that are present in the table). Unfortunately there is no "%VAR4%"
Can I still do something in the wpdatatables_before_get_table_metadata action? Or maybe in the wpdatatables_filter_mysql_query filter?
There is no documentation and examples for these hooks (which would be fair) so all that remains is to ask you for advice. I think it is normal to have more than three criteria in the WHERE clause, I am confused.
Hi,
I need information before purchasing another license.
I used wpdatatables_before_get_table_metadata to set a range of dynamic variable dates in a page:
$ wdtVar1 and $ wdtVar2 which I then used with "between"% VAR1% "AND"% VAR2% "in the sql query
All perfect :)
but...
For a new project, I would need additional variables to filter the result also on the third and fourth fields (that are present in the table).
Unfortunately there is no "%VAR4%"
Can I still do something in the wpdatatables_before_get_table_metadata action?
Or maybe in the wpdatatables_filter_mysql_query filter?
There is no documentation and examples for these hooks (which would be fair) so all that remains is to ask you for advice.
I think it is normal to have more than three criteria in the WHERE clause, I am confused.
Hoping for your reply, tanks
Axel
Hey Axel
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
I will forward this question to one of our developers, though. As soon as I hear back from him I will let you know.
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
Hi again Axel
Sorry for the late response.
You can add it as a custom solution. You'd also be able to use the filter for filtering the query:
function yourFunction( $query, $tableId ){ //your logic } add_filter('wpdatatables_filter_mysql_query', 'yourFunction',10,2);I hope that helps.
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
Hi Aleksandar,
thanks for your answer which gives me some hope.
I had already come to understand that this could be useful but unfortunately there is no documentation or examples for this (or others) filter.
I don't expect much, even just a small practical example of general use to avoid dozens of tests.
Thanks anyway
a.
You're welcome, Axel
Unfortunately I haven't done anything like this in the past, otherwise I would've shared an example with you.
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