Displaying foreign key value in ClientRowTemplate of KendoUI Grid

[Steven]

How do I go about showing the value of the foreign key (not the ID) within the ClientRowTemplate of a Grid?

[Petur Subev]

Hello Steven,

The KeyValuePairs (ID/Value) for particular ForeignKey column could be found the following way:

var collection; // global object which you can use as dictionary to get text for particular id
  function getTextByValue(data) {

      //if the collection is empty - get it from the grid
      if (!collection) {
          grid = $("#GridName").data("kendoGrid");
           valuesCollection = grid.options.columns[1].values;//Set the correct FKColumn index
          collection = {};
          for (var value in valuesCollection) {
              collection[valuesCollection[value].value] = valuesCollection[value].text;
          }
      }
      return collection[data.EmployeeID];
  }

You can use the function in yourRow template and pass the data to it to retrieve the Text.
e.g.

Text is : #= getTextByValue(data)#

Regards,
Petur Subev
the Telerik team

[pratik]

Can You Give Me a Demo Project of Foreign key use within the ClientRowTemplate of a Kendo Grid ?

 

Your Regard,

Pratik R. Panchal

[Boyan Dimitrov]

Hello pratik,

 

I am not able to understand completely the functionality you are trying to achieve. Could you please elaborate a bit more on your scenario? 

 

Regards,
Boyan Dimitrov
Telerik