We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Nested foreign key columns in grid

Thread ID:

Created:

Updated:

Platform:

Replies:

149887 Dec 13,2019 12:50 AM UTC Dec 13,2019 09:55 AM UTC Angular - EJ 2 1
loading
Tags: Grid
Ameet
Asked On December 13, 2019 12:50 AM UTC

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 [Syncfusion]
Replied On December 13, 2019 09:55 AM UTC

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon