How to manage or hide filter "In in list"

Hello, Giovanni,

The IsEqualTo and IsInList  filter options may sound similar but they differ in their implementation and might be useful in different cases according to client needs. I am providing more information about the filter operators that they use and the final filtering expression as a string.

The IsEqualTo option uses the FilterOperator.IsEqualTo, and the expression looks like this: [CustomerID] = '2'.
The IsInList oprion uses FilterOperator.IsContainedIn , and the expression is "[CustomerID] IN ('2')".

According to the question about filtering only date without the time part, note that GridViewDateTimeColumn exposes a FilteringMode property which determines how the DateTime values are being filtered. Here is how you can set this property:

GridViewDateTimeColumn  dateColumn = this.radGridView1.Columns["ShippedDate"] as GridViewDateTimeColumn;
dateColumn.FilteringMode = GridViewTimeFilteringMode.Date;

More information about GridViewDateTimeColumn is available here.

As to your last questions in this post, the FilterDescriptor.FilterExpression gives you access to the filter applied in RadGridView. However, please have in mind that it uses SQL-like format but it can't be completely considered as SQL compatible. RadGridView has its own parsing logic for interpreting the filter expressions. It is improved in such a way that the parsing logic can understand different formats as input. However, the returned expression follows the rules defined in RadGridView, not for SQL.

Regards,
Nadya | Tech Support Engineer
Progress Telerik

Hello, Giovanni,

According to the provided information it seems that you use CompositeDataFilterForm which uses RadDataFilter control. When you are having a string column, the filter expresions that are about to shown are relevant for string values. The "Is in list" option filters the rows by checking if the enered text is in the list. For example, if I type "King" in the text box, the grid would be filtered and show only the rows that contain this string in Last Name column:

However, if you want to remove the "Is in list" options from available filters you can use the following code snippet:

 private void RadGridView1_CreateCompositeFilterDialog(object sender, GridViewCreateCompositeFilterDialogEventArgs e)
 {
     CompositeDataFilterForm filterDialog = e.Dialog as CompositeDataFilterForm;
     filterDialog.DataFilter.EditorInitialized += DataFilter_EditorInitialized;
 }

 private void DataFilter_EditorInitialized(object sender, TreeNodeEditorInitializedEventArgs e)
 {
     TreeViewDropDownListEditor ddl = e.Editor as TreeViewDropDownListEditor;
     if (ddl != null)
     {
         BaseDropDownListEditorElement element = ddl.EditorElement as BaseDropDownListEditorElement;
         //remove "Is in List" filter option
         element.Items.RemoveAt(5);
     }
 }

I hope this helps. Should you have any other questions, do not hesitate to contact me.

Regards,
Nadya | Tech Support Engineer
Progress Telerik

Thank you!

It is not clear to me the meaning of that kind of filter...it seems to me the same as "equal to"...

Anyway thank you for the code to hide the filter.

If you can help me, I have a further question: is there a way to custom generate the expression?

I've noticed that for the date columns to I have a problem, because the radDataFilter.Expression generated is:

[myDate] >= #11/20/2023 14:55:07# 

I would like to have only the date without time, is it possible?
And  how can manage this expression to generate the SQL expression, cause the # is not accepted.