Grid remote filtering error

[khaeljy]

Hi,

I have an issue with grid filtering (Menu filter) using remote DataManager.
When i start typing in the autocomplete filter field, an error appear : "Request failed".

I have make a StackBlitz to illustrate this issue : https://stackblitz.com/edit/angular-tn21dx?file=app.component.html
For create my StackBlitz, I have clone an exemple of Syncfusion : https://ej2.syncfusion.com/angular/demos/#/material/grid/remote-data

Then I have only adds [allowFiltering]="true" [filterSettings]="{ type: 'Menu'}" to the ejs-grid component.

I think the problem comes from the return format of the remote data which should not be the same between the grid and the autocomplete filter field.

[khaeljy]

Please, up.

[Ajithbala]

Hi Team,

Thanks for your patience.

Query: when i start typing in the autocomplete filter field, an error appear : "Request failed"

We are tried to reproduce the reported issue, but it was unsuccessful at our end. Filtering a value on autocomplete control is working fine. onFiltering it sends the filter query to the server and returns Items in Object format to the client-side. Refer to the below code example and screenshot more information.

Screenshot 1: filtering on autocomplete control

Screenshot 2: Request to the server

Screenshot 3: Response from the server

Controller.cs

public object Get() 
        { 

            var queryString = Request.Query; 
            var data = OrdersDetails.GetAllRecords().ToList(); 
            string sort = queryString["$orderby"];   //sorting      
            string filter = queryString["$filter"]; 
            string auto = queryString["$inlineCount"]; 
            if (sort != null) //Sorting 

```            { 
------- 
            } 
            if (filter != null) // Filtering 
            { 
--------- 
 
            } 
 
            int skip = Convert.ToInt32(queryString["$skip"]); 
            int take = Convert.ToInt32(queryString["$top"]); 
            if (auto ==null) 
            { 
                return new { Items = data}; // return items only when searching a value in autocomplete control 
            } 
            else 
            { 
                return take != 0 ? new { Items = data.Skip(skip).Take(take).ToList(), Count = data.Count() } : new { Items = data, Count = data.Count() }; 
            } 
        } 

Find the below sample for your reference.

Sample: https://www.syncfusion.com/downloads/support/forum/154723/ze/1547231155248511.zip

UG: https://ej2.syncfusion.com/angular/documentation/grid/data-binding/#web-api

If you still face the same issue, please share the below details with us.

1. Full Grid code you have used.
2. Screenshot of syncfusion packages in package.json file.
3. Screenshot of request and response in network tab when filter a value on autocomplete control.
4. If possible, share the issue reproducible sample or make the issue in the given sample.

Regards,
Ajith G.

[ajithr]

We are closing this issue since there is no recent activity. Feel free to reopen this and update your comments for reinvestigation.