This is a migrated thread and some comments may be shown as answers.

Reload RadFilter from Saved Query in DB

5 Answers 105 Views
Filter
This is a migrated thread and some comments may be shown as answers.
Rekha
Top achievements
Rank 1
Rekha asked on 20 Jul 2012, 07:24 AM
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.

5 Answers, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 24 Jul 2012, 03:36 PM
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
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
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
Daniel
Telerik team
answered on 17 Aug 2012, 12:52 PM
Hello Tom,

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) ?

Tags
Filter
Asked by
Rekha
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Rekha
Top achievements
Rank 1
Tom Rasmussen
Top achievements
Rank 1
SPH
Top achievements
Rank 1
Share this question
or