Using Lookup Field in Grid

BIZ TMS XData
1

I am using the crud template and trying to use one of the columns as a lookup in a grid.

Setting this in the Fields of TXDataWebDataSet. The Entity names and field names are correct. But the column shows blank in the grid (TWebDBTableControl).

Agency
Agency394×658 15 KB

  1. Have I stuffed something up ?
  2. Or this doesnt work in Xdata
    • In which case, what's the recommended way to implement it ?
2

Inspect the JSON response from the request. Possibly the lookup field is being retrieved as proxy or entity representation in the JSON, thus with a different field name, as described here: JSON Format | TMS XData documentation

If that's the case you should properly fine tune your request by using $expand to retrieve the lookup data inline.