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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Grid Edit Foreign Key Column with Remote data using Angular

Thread ID:





122137 Feb 19,2016 10:44 AM UTC Mar 2,2016 09:57 AM UTC JavaScript 3
Tags: ejGrid
Yann Bruneau
Asked On February 19, 2016 10:44 AM UTC


I am trying to use the Foreign Key feature of the grid to be able to edit a country list using a dropdown. Strangely, it works using local dat but not using remote data?

{field: "CountryCode", headerText: "CountryCode", dataSource: $scope.ListCountry, foreignKeyField: "value", foreignKeyValue: "text"}

$scope.ListCountry = [{ text: "Country 1", value: 0 }, { text: "Country 2", value: 1 }, { text: "Country 3", value: 2 }]; -> WORKS

$scope.ListCountry = ej.DataManager({ url: "/api/GetListCountry", adaptor: new ej.UrlAdaptor() }); -> DOES NOT WORKS

This is what "/api/GetListCountry" return:

[{"value":0,"text":"Andorre"},{"value":1,"text":"Émirats Arabes Unis"},{"value":2,"text":"Afghanistan"},{"value":3,"text":"Antigua-et-Barbuda"},{"value":4,"text":"Anguilla"}.....]

Thank you,


Prasanna Kumar Viswanathan [Syncfusion]
Replied On February 22, 2016 09:45 AM UTC

Hi Yann,

Thanks for contacting Syncfusion support.

We checked your code example and suspect that you need “URL adaptor within the columns.” Do you want to bind URL DataSource for a specific column? Could you please confirm if it is your requirement?


Prasanna Kumar N.S.V

Yann Bruneau
Replied On March 1, 2016 01:08 PM UTC


Sorry I was in holiday.

Yes, I need the column Country to be bound to a remote country list when in Edit Mode. I am able to make it works with a local countrylist but not with a Remote one.

Thank you,


Prasanna Kumar Viswanathan [Syncfusion]
Replied On March 2, 2016 09:57 AM UTC

Hi Yann,

We would like to let you know that we have already logged feature request for “Url dataSource for foreign key columnsand have added your requirements to the description of the feature. A support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates. 



Prasanna Kumar N.S.V


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