Filter UI for multselect grid column does not show up

[gabor]

Please find all code in the attached sample project, which uses .ASP.NET Core 3.1 and the latest Syncfusion NuGet package ("Syncfusion.EJ2.AspNet.Core" Version="18.3.0.42"), and  CDN   "https://cdn.syncfusion.com/ej2/dist/ej2.min.js"

Note: The attached code is just an isolated sample, some functionality is missed and not working which is not a problem, but exhibits the very same issue as in our real project. The filter UI issue is not specific this project.

***

There is a field in the grid's datasource which is an array (or list), this always the if the column has multiselect capabilities. (This case this field is the string[] CustomerID). .A do understand, that make filter working requires special processing the "where" part of   the DataManagerRequest in the OnPostDataSource([FromBody] DataManagerRequest request) method. I do not ask for that, I do know how to implement and case that part.

Instead, I have problem in the UI. Because the corresponding field is an array or list the filter UI does not show up, instead a javascript error occurs.

I would like to the filter UI to show up, allow input an operator like startswith and value to filter like "hello" and send this to the server in the DataManagerRequest, as a "where" for the CustomerID field, and I will do care how to correctly process this to a query. With other words the UI should work for this column just as it works for a regular string field in a text column

Attachment: FilterUIForMultiSelectCell_1d3cc6d0.rar

[Ajith Govarthan]

Hi Gabor, 

Thanks for contacting syncfusion support. 

Query: I have problem in the UI. Because the corresponding field is an array or list the filter UI does not show up, instead a javascript error occurs. 

 

Based on your update you have mentioned that the CustomerID column is an array type . By default in EJ2 Grid the filter dialog will be opened based on the column data type. In EJ2 Grid we do not have support to filter the array type column data,  so it throws the script error when you open the filter dialog.  

Please get back to us if you need further assistance. 

Regards, 

Ajith G. 

[Meghana]

Hey, 

Know more about this issue at http://www.dotnet.idn-kxchange.com/forums/recent_topics

[Ajith Govarthan]

Hi Gabor, 

Thanks for the update. 

Query: Hey, Know more about this issue at http://www.dotnet.idn-kxchange.com/forums/recent_topics  

 

Based on your query you want to filter the array type column data in EJ2 Grid component. By default in EJ2 Grid the filter dialog will be opened based on the column data type. In EJ2 Grid we do not have support to filter the array type column data,  so it throws the script error when you open the filter dialog and also the filtering of the data is done only based on string, number or date type only at our end and it is not feasible to filter array type values in the grid component. 

We have also noticed that you have attached the a reference link and from that link we are unable to find the Syncfusion related queries so please explain more details on the attached reference link. For your convenience we have attached the documentation of the data binding in the grid component so please refer the documentation for your reference. 

UG-links: 

https://ej2.syncfusion.com/aspnetcore/documentation/grid/columns/#columns 

https://ej2.syncfusion.com/aspnetcore/documentation/grid/data-binding/#data-binding 

Regards, 

Ajith G.