SfGrid dynamic Query for WebApiAdaptor not used for filter-preview

[Andrzej]

Hello, I prepared a sample code for SfGrid where I defined some Query and used a SfDataManager with WebApiAdaptor.

When the grid gets all data from ApiCustomerController via [HttpGet] then my additional parameter "test1" from GridQuery is preserved correctly in Request.Query.

However when I enter some text into a filter-field and the grid tries get some first rows from the adapter, then the Request.Query doesn't contain my GridQuery anymore.

It worked properly in Syncfusion Blazor 18.1. What I must define to make it working in 18.4?

In attached project, the test page GridQueryFilter is called from NavMenu under "Grid Query Filter".

Best regards

Attachment: TestBlazorFilterQuery_7a7a481b.rar

[Renjith Singh Rajendran]

Hi Andrzej, 

Greetings from Syncfusion support. 

Based on this scenario, we suggest you to use FilterTemplate feature of Grid. With this feature you can render a custom SfAutoComplete component and assign the query to the Query property of SfAutoComplete. Please refer the codes below, 

 

<GridColumn Field=@nameof(Customer.Name) HeaderText="Name" TextAlign="TextAlign.Right" Width="120"> 

    <FilterTemplate> 

        <SfAutoComplete Placeholder="Enter the Name" ID="Name" @bind-Value="@((context as PredicateModel<string>).Value)" Query="GridQuery" TItem="Customer" TValue="string"> 

            <SfDataManager Url="/api/ApiCustomer" Adaptor="Adaptors.WebApiAdaptor"></SfDataManager> 

            <AutoCompleteFieldSettings Value="Name" Text="Name"></AutoCompleteFieldSettings> 

        </SfAutoComplete> 

    </FilterTemplate> 

</GridColumn> 

Reference : https://blazor.syncfusion.com/documentation/datagrid/filtering/#custom-component-in-filter-menu 

 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran 

[Andrzej]

Thanks for the hint, however I have more than twenty columns in this grid. Must I define a separate template for each one? Maybe there is a simpler way? What happened with previous logic in version 18.1 which worked correctly and preserved the query automatically? 

Regards

Andrzej

[Vignesh Natarajan]

Hi Andrzej, 

Thanks for the update.  

Query: “Maybe there is a simpler way? What happened with previous logic in version 18.1 which worked correctly and preserved the query automatically? ” 

We have analyzed the reported query and we are also able to reproduce the reported issue (Query property value is not sent to server when typing a value in filter menu) at our end. We have confirmed it as a bug and logged the defect report “Grid Query does not exist the QueryString when filtering a entering a value in menu filter” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the defect fix in our weekly release which is expected to be rolled out by mid of February, 2021.  

       

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.       

   

https://www.syncfusion.com/feedback/21316/  

  

Till then we appreciate your patience.   

Regards, 

Vignesh Natarajan 

[Andrzej]

Thank you for the info. I will wait for a new version.

Regards

Andrzej

[Vignesh Natarajan]

Hi Andrzej,  

Thanks for the update. 

Kindly track the state us of the issue using the below feedback link.  

https://www.syncfusion.com/feedback/21316/  

Please follow our Syncfusion page for release related information. We will get back to you once the reported issue is fixed and included in our patch release.   

Regards, 

Vignesh Natarajan 

[Vignesh Natarajan]

Hi Andrzej,

 

We are glad to announce that our weekly patch release (v19.1.0.55) has been rolled out successfully and we have included the fix for “Grid Query does not exist the QueryString when filtering a entering a value in menu filter” issue in our 18.4.0.44 patch release. So kindly update your NuGet (Syncfusion.Blazor) to our latest version (19.1.0.55) or minimum of 18.4.0.44 version  to resolve the reported issue 

 

Please find the Nuget package and release notes from below 

 

Nuget: https://www.nuget.org/packages/Syncfusion.Blazor/ 

 

Release Note: https://blazor.syncfusion.com/documentation/release-notes/18.4.44/?type=all#grid 

 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.  

 

Regards, 

Vignesh Natarajan 

[Andrzej]

Thanks, it works correctly.

[Vignesh Natarajan]

Hi Andrzej, 

Thanks for the update.  

We have glad to hear that your issue has been resolved. Kindly get back to us if you have further queries.  

Regards, 

Vignesh Natarajan