changing filtering method with grid and dhtmlxconnector


I was wondering is there a way to change the type of queries that are used in conjunction with the grid filtering and dhtmlxconnector. Currently is will use a “LIKE” query, i would like to include a backend function in the database. instead of say sql.field like ‘%value%’, i would like to include sql.field=function(value) for my filtering. the database is postgres.

thanks for the help.


You can use “beforeFilter” event. Please find more information here … forefilter … :filtering … xconnector