Filter Data from Nested Class

Question

How to add this Column to the filter querystring?@using Syncfusion.Blazor @using Syncfusion.Blazor.Data @using Syncfusion.Blazor.Grids @code{ public class Order { public int? OrderID { get; set; } public string CustomerID { get; set; } public DateTime? OrderDate { get; set; } public double? Freight { get; set; } } } @((context as Rate).rateClass.RateClassDesc ) Thank You!

Rahul Narayanasamy · Answer

Hi Michael, 

Greetings from Syncfusion. 

We have validated your query and we suspect that you want to perform filtering operation with WebApiAdaptor. For WebApi, you need to handle the data operations(such as sorting, filtering, paging etc) in API controller. You can receive a querystring(Request.Query) contains skip, take and other values(for sorting, filtering) values in WebApi controller. Based on the querystring, you need to handle the data operations(sorting, filtering) at controller side. Here, we have prepared a sample based on your requirement. 





[HttpGet] 
        public async Task<object> Get(int? code) 
       { 
            if (order.Count == 0) 
            { 
                BindDataSource(); 
            } 
            var data = order.AsQueryable(); 
            var queryString = Request.Query; 
            string grid = queryString["ej2grid"]; 
            string sort = queryString["$orderby"];   //sorting       
            string filter = queryString["$filter"]; 
            string auto = queryString["$inlineCount"]; 
            if (filter != null) // to handle filter opertaion 
            { 
                if (filter.Contains("substring"))//searching  
                { 
                    var key = filter.Split(new string[] { "'" }, StringSplitOptions.None)[1]; 
                    data = data.Where(fil => fil.CustomerID.ToString().Contains(key.ToUpper()) 
                                            || fil.EmployeeID.ToString().Contains(key) 
                                            || fil.Freight.ToString().Contains(key) 
                                            || fil.OrderID.ToString().Contains(key)); 
                } 
                else 
                { 
                    var newfiltersplits = filter; 
                    var filtersplits = newfiltersplits.Split('(', ')', ' '); 
                    . . . 
 
                    switch (filterfield) 
                    { 
                        case "OrderID": 
                            data = (from cust in data 
                                    where cust.OrderID.ToString() == filtervalue.ToString() 
                                    select cust); 
                            break; 
                        case "CustomerID": 
                            data = (from cust in data 
                                    where cust.CustomerID.ToLower().StartsWith(filtervalue.ToString()) 
                                    select cust); 
                            break; 
                        . . . 
                } 
            } 
            if (sort != null) //Sorting  
            { 
                var sortfield = sort.Split(','); 
                . . . 
            } 
            if (queryString.Keys.Contains("$inlinecount")) 
            { 
                . . . 
                 return new { Items = data.Skip(skip).Take(top), Count = count };                
            } 
            else 
            { 
                return data; 
            } 
        } 

Sample: https://www.syncfusion.com/downloads/support/forum/164242/ze/WebAPIAdaptorSample-135800026  

Documentation :  
https://blazor.syncfusion.com/documentation/datagrid/data-binding/#web-api 
https://blazor.syncfusion.com/documentation/data/adaptors/#web-api-adaptor  

Please let us know if you have any concerns. 

Regards, 
Rahul