Nested foreign key columns in grid

[Ameet]

I have country and state columns in the grid. They are foreign keys from country and stateprovince table. 

How do I pass the particular row's countryid to the state datasource to filter those rows? Here is how it displays.

Your help is greatly appreciated.

Thank You,

Regards,

Ameet

[Thavasianand Sankaranarayanan]

Hi Ameet, 

 

Thanks for contacting Syncfusion support. 

 

By default, while using foreignKey column then it map(filter) the grid data source(CustomerID) with foreignkey data source(CustomerID) based on the mapping value(VINET) and return the result('Pual Henriot'). Please refer the below sample and help documentation for more information. 

 

Demo sample : https://ej2.syncfusion.com/angular/demos/#/material/grid/column/foreign-key 

 

Help documentation : https://ej2.syncfusion.com/angular/documentation/grid/columns/?no-cache=1#foreign-key-column 

 

We could not able to view the attached image that you are provided in previous update. If the above does not meet your requirement then share more information about your query , table structure  and local/remote data binding etc., which helps us to analyze further and provide a better solution as soon as possible. 

 

Regards, 

Thavasianand S.