We currently use the RadFilterSqlQueryProvider to get a string representation of the filter control:
We store this string in the database to be used elsewhere. We also save the Base64 result from the SaveSettings() method to re-populate the control.
Is it possible to populate the filter from the sql string rather than the Base64 string? We'd like to avoid having two version of the filter expression saved. Can we somehow convert that string to the Base64 format the RadFilter control expects?
var provider =
new
RadFilterSqlQueryProvider();
provider.ProcessGroup(e.ExpressionRoot);
var expression = provider.Result;
We store this string in the database to be used elsewhere. We also save the Base64 result from the SaveSettings() method to re-populate the control.
Is it possible to populate the filter from the sql string rather than the Base64 string? We'd like to avoid having two version of the filter expression saved. Can we somehow convert that string to the Base64 format the RadFilter control expects?