1. Home
  2. Forum
  3. Blazor
  4. SfGrid dynamic Query for WebApiAdaptor not used for filter-preview

SfGrid dynamic Query for WebApiAdaptor not used for filter-preview

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

8 Replies
RS Renjith Singh Rajendran Syncfusion Team January 11, 2021 08:59 AM UTC

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> 


 
Please get back to us if you need further assistance. 

Regards, 
Renjith Singh Rajendran 


AN Andrzej January 11, 2021 09:16 AM UTC

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

VN Vignesh Natarajan Syncfusion Team January 12, 2021 07:38 AM UTC

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.       
   
  
Till then we appreciate your patience.   

Regards, 
Vignesh Natarajan 



AN Andrzej January 12, 2021 08:48 AM UTC

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

VN Vignesh Natarajan Syncfusion Team January 13, 2021 04:13 AM UTC

Hi Andrzej,  

Thanks for the update. 

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


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 


VN Vignesh Natarajan Syncfusion Team August 11, 2021 12:07 PM UTC

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 
 
 
 
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 


AN Andrzej August 11, 2021 12:28 PM UTC

Thanks, it works correctly.


VN Vignesh Natarajan Syncfusion Team August 12, 2021 03:20 AM UTC

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  


Loader.
Up arrow icon