changing filtering method with grid and dhtmlxconnector

Suite and Optimus Suite 5
#1

Hello,

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.

Msj

#2

You can use “beforeFilter” event. Please find more information here
docs.dhtmlx.com/doku.php?id=dhtm … forefilter
docs.dhtmlx.com/doku.php?id=dhtm … :filtering
docs.dhtmlx.com/doku.php?id=dhtm … xconnector