Is there any way to solve the problem with Int32 or DateTime columns when using the approach described in the K18434 article?

Hi Janis,

The CriteriaToWhereClauseHelper class simply converts the CriteriaOpeator passed to it into a corresponding expression. If there is an unsupported operation, such as applying the LIKE operator to a numeric column, this issue should be handled at the higher level.

If you describe how you build the CriteiraOperator, I can provide you with an appropriate solution.

Hi Uriah,
well i have a ColumnFilterChange event in which i want to use the DataView to be the datasource of a Chart. So i use the activeFilterCriteria of the GridView:

C#
DevExpress.Data.Filtering.CriteriaOperator op = oView.ActiveFilterCriteria;  

and use it as the RowFilter in the DataView:

C#
string strFilter = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetDataSetWhere(op);  
DataView oDataView = (DataView)oView.DataSource;  
oDataView.RowFilter = strFilter;  

After that i simpy assign the DataView to the chart:

C#
chartControl1.DataSource = oDataView;  

So my Problem is when i typed any filter in the Grid into a column with a datatype like int32 the Funktion GetDataSetWhere creates a string like "([Year] like '201%')". So i cant apply that string to the RowFilter property because the Year column is actually an int and wont allow the LIKE Operator.

Hi Janis,

Is it a strict requirement to allow users to use the "LIKE" operator against a numeric column? If not, I suggest disabling the auto filter row cell for this column and allowing users to choose an appropriate value via the column filter popup. Is this solution acceptable?

Hello Uriah,
thanks for the reply!
This is a good solution in my case but im facing another problem now. My columns can contain empty values. When im selecting "Blanks" in the column filter popup the filter string which is created via GetDataSetWhere looks like:
(([Activation_Date]) is null or (len([Activation_Date]) = 0))
The len() function Needs a string and won't allow dates (i dont know if thats work for ints. My int columns never contains empty values).
Do you have any suggestions how to solve this?