Hello
I use a radfilter and radgrid to populate some data. I am saving the RadFilter expression in Db using the following code.
RadFilterSqlQueryProvider provider = new RadFilterSqlQueryProvider();
provider.ProcessGroup(RadFilter1.RootGroup);
String result = provider.Result;
Now in one page , I want to edit this value in DB. i.e, I want to reload this saved query to radfilter from the value in DB and thereby rebind the grid accordingly.
Any help will be highly appreciated.
Regards
Rekha.
I use a radfilter and radgrid to populate some data. I am saving the RadFilter expression in Db using the following code.
RadFilterSqlQueryProvider provider = new RadFilterSqlQueryProvider();
provider.ProcessGroup(RadFilter1.RootGroup);
String result = provider.Result;
Now in one page , I want to edit this value in DB. i.e, I want to reload this saved query to radfilter from the value in DB and thereby rebind the grid accordingly.
Any help will be highly appreciated.
Regards
Rekha.
5 Answers, 1 is accepted
0
Hello Rekha,
It is not possible to just "reload" the string expression to the control. You should use one of the provided settings formatters (binary or Base64 string) if you need such functionality (save/load expressions).
Saving and Loading Filter Expressions
Best regards,
Daniel
the Telerik team
It is not possible to just "reload" the string expression to the control. You should use one of the provided settings formatters (binary or Base64 string) if you need such functionality (save/load expressions).
Saving and Loading Filter Expressions
Best regards,
Daniel
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Rekha
Top achievements
Rank 1
answered on 30 Jul 2012, 12:27 PM
Hello Daniel
Thank you so much for your response.
Regards
Rekha
Thank you so much for your response.
Regards
Rekha
0
Tom Rasmussen
Top achievements
Rank 1
answered on 14 Aug 2012, 07:38 PM
I would also like to see this capability. It would be beneficial for migrating from older stored string expressions to RadFilter expressions. An SQL expression parser (string to RootGroup) would be fantastic.
0
Hello Tom,
Thank you for your suggestions. I will pass your feature request to our developers for consideration.
Best regards,
Daniel
the Telerik team
Thank you for your suggestions. I will pass your feature request to our developers for consideration.
Best regards,
Daniel
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
SPH
Top achievements
Rank 1
answered on 23 May 2018, 08:45 AM
By any chance, is such a SQL to RadFilterExpression parser has been implemented or not ?
If not, what would be the most efficient way to programmatically define a very complex RadFilter (100 criterias) ?