Kinetic Browser Grid Filters - Off for some fields?

Kinetic ERP
1

Open a stock dashboard in the browser, Material Request Queue for example, and I notice some fields are not filterable..Customer ID being one of them.

I really would like to filter by this column here. Fire up application studio and make the column filterable. When I test it, I get an error when I enter criteria to filter the column by:

IceAppServer msg=“Possible SQL injection: ‘Unexpected keyword’.”

Is there a way to enable filtering on columns in grids that do not offer it by default in the browser or is this a thing that only works in classic?

2

Toggle progressive load mode. Its the arrow pointing down at the top right of the grid. If there is no arrow sometimes the control is in the overflow menu.
image

3 Likes
3

Thanks.

So to get these added fields to filter without error you need to first load every record VIA the Preload button and then start filtering?

This can’t be working as intended.

2 Likes
4

Yep pretty much.

3 Likes
5

right cuz using serverPaging by default then dynamically switching to client-side is hard (NOT!)


if (!hasMorePages) {
    var ds = $("#grid").data("kendoGrid").dataSource;

    ds.options.serverPaging = false;
    ds.options.serverSorting = false;
    ds.options.serverFiltering = false;

    // Optional: load all data into the DataSource
    ds.data(response.data);
}

:roll_eyes:

6

idgi

7

…just saying it’s not hard to handle server vs client paging, sort, filter. It’s buitlin to the grid control they’re using but Kinetic is not doing it right. Meanwhile they’re adding filter features on top of a broken paging framework.

3 Likes