Load filter from database in SQL format

[Sérgio]

Hello,

I'm trying to build an application which allows the user to create filters and save them in a database to be used with SSIS.
I'm able to save and load the filter in base64 format and i can also get the generated SQL with the RadFilterSqlQueryProvider.

I have to make the initial parametrization of the application, and it has lots and lots of filters and criteria and I would like to use something like a spreadsheet to build the string, something like ([Field1] = '7' AND [Field2] = 8), save it directly to the database (MS SQL Server 2008) and have RadFilter parse those strings.
Then the user would be able to edit the filters and I wouldn't have to build them "manually" via webform. :)

I'm using VS2010 with ASP.Net Ajax Q1 2012 SP1

Can anyone show me the light? :)

[Vasil]

Hello sergio,

If you use the RadFilter to filter your values you could store the encoded settings in your database and use the SaveSettings and LoadSettings methods of the RadFilter.
For the initial creation of the filters, you will need to parse the spreadsheet like file yourself and to add the expressions manually on the Page_Load event similar to this online demo
http://demos.telerik.com/aspnet-ajax/filter/examples/customeditors/defaultcs.aspx

Greetings,
Vasil
the Telerik team

[Sérgio]

test