convert Json filter expression to sql expression

[alooosh]

Hi experts , I am using server side filter on my grid . I am not using JSP wrappers it is just  normal kendo grid connected to servlet where to obtain data. I am giving the user to filter any coulmns as he wishes on my grid. what I am looking for is I need to translate the JSon filter made by the user to sql expression so I can use it to retreive data from the database. my Json filter representation is as below 

{"logic":"and","filters":[{"field":"name","operator":"startswith","value":"ji"},{"field":"name","operator":"contains","value":"m"},{"field":"price","operator":"eq","value":"55"}]}

it is too much difficlut for me to translate it to sql expression . I have searched a lot , all I found on ASP not the JSP 

 

please help me at least with the method/function to convert the json correctly as it is made by user on grid.

[Vladimir Iliev]

Hi Alooosh,

Currently we have no such demo of translating filter object to SQL query which we can provide. As such custom solutions falls outside the scope of our support service I could only suggest to check our premium services. 

Regards,
Vladimir Iliev
Telerik