Externa filter in grid is not working as expected when we apply grouping

[Naresh]

Hi team,

On the external filtering sample under the grid, I wanted a filter condition like the below :

(Product Name starts with 'c' And Product Name ends with 'i') OR Product Name is equal to  'Ikura'

Using this filter, I expected to get chai and ikura as filtered results.  but the filter gave me zero results back.

Can you please tell me why this selection of filters gave no results back? Also, what filters do I need to use to accomplish my requirement of getting chai and ikura as my results?

I am attaching the screen capture of my selected filter options for your reference.

Regards,
Naresh Ravlani.

 

[Hetali]

Hello Naresh,

Thank you sharing the details.

Based on the image shared, this is the logic that is applied:

Product Name starts with 'c'  && Product Name ends with 'i' && (Product Name is equal to  'Ikura' || )

In order to see Chai and Ikura as the filter result, please modify the filter with the following options:

This is the logic that will be applied:

(Product Name starts with 'c'  && Product Name ends with 'i' ) || (Product Name is equal to  'Ikura' && )

I hope this information provides more clarity with External Filtering. Please let me know if I can further assist you.

Regards,
Hetali
Progress Telerik

[Naresh]

Hi Hitali,

Thank you for the response. I think now I understood how this filtering is working.

Regards,
Naresh Ravlani.