Odd filtering behavour

[Andrew Fraser]

I am struggling with the filter operation on the data grid.

Let's say I have a column called Items that contains the following rows of data:

FRUIT - APPLE
FRUIT - ORANGE
FRUIT - PEAR
VEGETABLE - CABBAGE
VEGETABLE - CORN

When I select the filter Starts with and type FRUIT, it tries to auto complete but I want it to filter on *ALL* rows that start with FRUIT. I cannot simply type FRUIT as if I tab out of the dropdown so that I can click the Filter button, it forces the selection of one item.

What am I doing wrong?

And

[Sanjay Kumar Suresh]

Hi Andrew Fraser,

Greetings from Syncfusion,

Based on your query, we understand that you want to filter values without using the autocomplete suggestions in the Grid filter menu.

To achieve this, you can configure the FilterEditorSettings property of the GridColumn component. Specifically, by disabling the AutoFill option in AutoCompleteFilterParams, the filter input will no longer automatically populate values from the suggestion list, allowing you to enter and filter values manually.

Please refer to the code snippet below for implementation details.

Code Snippet:

<SfGrid DataSource="@Items" AllowFiltering="true" Height="300px">

    <GridFilterSettings Type="Syncfusion.Blazor.Grids.FilterType.Menu"></GridFilterSettings>

    <GridColumns>

        <GridColumn Field=@nameof(ItemData.ItemName)

                    HeaderText="Items"

                    Width="200"

                    Type="Syncfusion.Blazor.Grids.ColumnType.String"

                    FilterEditorSettings="ItemNameFilterSettings">

        </GridColumn>

    </GridColumns>

</SfGrid>

 

@code

{

    public IFilterSettings ItemNameFilterSettings = new AutoCompleteFilterParams

    {

        AutoCompleteParams = new AutoCompleteModel

        {

            Autofill = false,

        }

    };

…

 

Sample: https://blazorplayground.syncfusion.com/embed/LjLRtdDqLeubwyJB?appbar=true&editor=true&result=true&errorlist=true&theme=fluent2

Video Demo: Check the Attachment.

Feel free to get back to us if you have any concerns.

Regards,

Sanjay Kumar Suresh

Attachment: FilteringDisabledAutoFill_6ab26c1b.zip

[Andrew Fraser]

I have tried what you suggest but that does not allow me to filter the grid contents by partial text. Using my example above, if I type FRUIT into the filter box and hit tab or return, the grid becomes empty. If I open the filter box again it has put a question mark in the text field. I would like to type FRUIT into the filter box and the grid would list the following:

FRUIT - APPLE
FRUIT - ORANGE
FRUIT - PEAR

Is this possible?

Andy

[Sanjay Kumar Suresh]

Hi Andrew Fraser,

Thanks for your update,

Based on the update shared above, we understand that the suggested approach did not work at your end. Before proceeding further with the reported requirement, we need some additional clarification from your side to investigate this effectively. Kindly provide the following details so that we can proceed further from our end.

      1. Please provide a simple issue replicating sample or try to modify the sample in the previous response.

      2. Please share us the complete Grid code snippet, along with your customizations.

      3. Please provide the NuGet version in which the issue is getting reproduced from your end.

      4. Share us the video demonstration of the reported issue.
 

The above requested detail will be very helpful for us to validate the reported issue at our end.

Regards,

Sanjay Kumar Suresh

[Andrew Fraser]

I have resolved my issue by changing the filter type to Syncfusion.Blazor.Grids.FilterType.FilterBar.

Not sure why Syncfusion.Blazor.Grids.FilterType.Menu was not working for me as using SyncFusion Blazor Template Studio to create a demo seemed to work fine with either Menu or FilterBar mode.

Andy

[Sanjay Kumar Suresh]

Hi Andrew Fraser,

Thank you for your update.

Yes, changing the filter type to FilterType.FilterBar meets your requirement of filtering only the typed value in the filter text box. This behavior is expected when using the FilterBar mode.

However, if your exact requirement is to achieve the same filtering behavior using FilterType.FilterMenu, please share the requested concern details mentioned earlier. This will help us better understand your scenario and assist you more effectively.

Regards,

Sanjay Kumar Suresh