pavinan/java.devextreme.helpers.datasource

Creates a sql where clause from DevExtreme remote datasource with filtering.

DevExtreme helpers remote datasource.

Ported from DevExtreme.Helpers.DataSource written in C#.

WhereClauseBuilder builder = new WhereClauseBuilder();
String json = "[\"CustomerID\",\"=\",\"ALFKI\"]";
JsonArray jArray = (JsonArray) (new JsonParser().parse(json));
String sqlWhereClause = builder.buildFor(jArray);

Outputs:

CustomerID = "ALFKI"

In sql you can write

Exec('Select * from customers where ' + @sqlWhereClause);

There is an overloaded version of WhereClauseBuilder you can provide your own implentation SQLColumnProvider if you are using table aliases you can customize there.