Hi, I need to use Boolean logic (AND, OR, NOT operators) in filter and search restrictions to create more complex and precise criteria. Can I do it for each column’s filter?
Unfortunately something like this is not available in our plugin build-in and requires some code customization. We can offer you our paid customization service where you can hire one of our developers to implement this functionality for you. If you are interested please give us detailed instructions and we can send you quote for this service.
If not, I can give you this hints so maybe they can help you out. If you take a look at our documentation about filters you can find this filter
wpdatatables_filter_mysql_query( $query, $table_id )
This filter is applied to the MySQL query before it is sent to MySQL server.
$query is the query text, $table_id is the table identifier from the MySQL table (wp_wpdatatables).
The function is in the file class.wpdatatable.php called queryBasedConstruct
Hi, I need to use Boolean logic (AND, OR, NOT operators) in filter and search restrictions to create more complex and precise criteria. Can I do it for each column’s filter?
thanx
Hi xadoom86,
Thank you for your purchase.
Unfortunately something like this is not available in our plugin build-in and requires some code customization.
We can offer you our paid customization service where you can hire one of our developers to implement this functionality for you.
If you are interested please give us detailed instructions and we can send you quote for this service.
If not, I can give you this hints so maybe they can help you out.
If you take a look at our documentation about filters you can find this filter
wpdatatables_filter_mysql_query( $query, $table_id )
This filter is applied to the MySQL query before it is sent to MySQL server.
$query is the query text, $table_id is the table identifier from the MySQL table (wp_wpdatatables).
The function is in the file class.wpdatatable.php called queryBasedConstruct
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