Grid with update using fresh SQL call

Suite and Optimus Suite 5
#1

It appears that my best bet for user-searching data in my grid is for a fresh sql command to be issued. This is because

  • My data is in unicode with special characters that need to be searched using “normal” characters input by the user. This is how MySQL does it by default.

  • I would like to use full-text searches, again, something easy to do with an sql call to MySQL.

I am not clear on how to do this, though it appears that there is more than one way to accomplish this. Could someone help me out, with SPECIFICS?

I need to know how to pass a search string back with the sql call, and how to trigger the grid update with an sql command.

Thanks. Hope someone can help me on this.
JS

#2

The common way is to use the dhtmlConnector for your grid.
For example:
docs.dhtmlx.com/connector__php__index.html
It can be downloaded here:
dhtmlx.com/docs/products/dhtmlxConnector/

#3

Hi, and thanks for you kind reply.

However, I really do need SPECIFICS. I am using the connector now, and it pulls up my data into the grid with no problem.

The question is: When I have a use enter a search value, how can I get the connector to perform a new sql query? The Grid’s search methods are not sufficient for reasons I’ve said.

Thanks,
JS

#4

Hi,

Connector provides ability to apply server-side search. And you can customize default filtering logic via beforeFilter event. Here are docs about this functionality:

docs.dhtmlx.com/connector__php__ … lter_types

If you want to perform own search request (do not use built-in search field), you can reload grid with new data and use render_sql method instead of render_table in php script:

docs.dhtmlx.com/connector__php__ … ral_tables