Can I filter a datagrid column with SQL?

[gib65]

Hello,

I'm experimenting with filtering on the EasyUI datagrid. I'm wondering if the API has any functions for filtering that can handle SQL string, at least a WHERE clause.

For example, if Status is one of the columns:

dg.datagrid("addFilterRule", "WHERE Status = 'N'");

Is there anything like this in the API?

[stworthy]

Please look at this topic https://www.jeasyui.com/forum/index.php?topic=3710.0

[gib65]

Thanks for the article stworthy,

By the sounds of it, it seems like I'd have to convert the json string that the filter gives me and programmatically convert it to SQL.

[stworthy]

The datagrid sends the filter rules to server. You must decode it and convert to the SQL according to your database. Please refer to this example https://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=Remote%20Filtering%20on%20DataGrid