Asp.Net Core Syncfusion grid search bar should search in both parent & child grid

Question

Hello.I'm developing a small application in Asp.Net Core and using Syncfusion grids.I have a grid (of Products) with child grid (of product UOM). I have search bar on parent grid which is working fine (on parent grid only). But i want the search to be perform on both grids. Means if user type a keyword it should search in child grid's datamanagerAlso is it possible that if user type a UOM / Price (which exists in child grid) the parent grid Also is it possible to filter parent grid's rows when user type UOM/Price (which exists in child grid). I mean parent grid datamanager should filtered on behalf of child grid datamanager.Hope you understand what i mean.I'm using ODataV4Adapter for both grids.Here is my Parent Grid:

Here is my Child Grid Code:here is my Grid Output:

Sujith Kumar Rajkumar · Answer

Hi Anjum, 
 
Greetings from Syncfusion support. 
 
The Grid’s search functionality works on basis of comparing the searched key value with the underlying data source bound to the grid for local data and for remote data sends request to the defined server url to fetch and update the Grid data. The child Grids are individually initialized Grid controls(on parent row expand) with its own data and actions. So for performing search on the child Grid we need to define the search toolbar in the child Grid separately. This is the default behavior of this case based on the Grid’s current architecture and so it is not feasible to achieve your requirement. 
 
Let us know if you have any concerns. 
 
Regards, 
Sujith R

Anjum Habib · Answer

Thanks for your time.so if parent grid can't be filtered with child grid data.then can we render both Parent & Child grids with same data source? I mean grid data source return relational data with list of Product and each product having its UOM(s). Also when we perform a search it will query both parent & child entities Kindly share some example code (if any).

Joseph Christ Nithin Issack · Answer

Hi Anjum, 

   Thanks for your update. 

   Based on your requirement, you want to search both the parent and the child grid using the search key word of the parent grid. You requirement can be achieved by getting the search keyword of the parent grid in the `dataBound` event of the child grid and then you can search the child grid with the keyword using the `search` method of the child grid. 

Please refer the below code example:  





var grid = new ej.grids.Grid({ 
  --------------------------- 
  --------------------------- 
  childGrid: { 
    dataSource: dataManger, 
    dataBound: function (args) { 
      var parentGrid = document.getElementById(this.parentDetails.parentID) 
        .ej2_instances[0]; 
      this.searchSettings = { key: parentGrid.searchSettings.key }; 
    }, 
    allowSearching: true, 
    queryString: 'EmployeeID', 
    allowPaging: true, 
    toolbar: ['Search'], 
    ---------------------------------- 
    ---------------------------------- 
  }, 
}); 
grid.appendTo('#Grid'); 



Sample: https://stackblitz.com/edit/gqmqqz 

Please get back to us for further details. 

Regards, 
Joseph I.