Data of fields which have relations

WEB TMS WEB Core
1

I have a master and detail table and I have set the relationship in the database

{
  • value: 
    [
    • {
      • $id: 1,
      • CustomerName: "COMPAS ",
      • Min1: null,
      • Min2: null,
      • Max1: null,
      • Max2: null,
      • CreatedBy: null,
      • CreatedDate: null,
      • ModifiedBy: null,
      • ModifiedDate: null,
      • Customer_id@xdata.ref: "Customer('C001')",
      • Service@xdata.ref: "Service('%25%20Butyl%20Cell')"
      },
    I have the a Xdatawebdataset connected to it and the I am able to retrieve the data
  • But fields which have connected to other tables are not showing up in the edit field. Like I want to show C001 or the Service code. Currently it is showing up as null. 
2

You have to add 

$expand=Customer_id,Service
to your request URL (see http://www.tmssoftware.biz/business/xdata/doc/web/expand.html).
This way the JSON will come expanded, and then in the XDataWebDataset you can simply add fields like Customer_id.id or Service.Name
3

I have tried doing what you have suggested.  I have two issues


This is the result I am getting from my query
4

My next issue is if I have to modify the Distribution_name which is shown as an object, How do I assign a new value to it ?

5

You have to create such field in the database. 

If you want to the dataset to create all subfields automatically, you can set SubPropsDepth to 1, see http://www.tmssoftware.biz/business/xdata/doc/web/using-txdatawebdataset.html
To change the distribution, you need to assign another JS object to the "Distribution_name" property.
Usually you would gather from the server a new object and simply assign the whole object to the field.
6

To RE-ASK Shah Rahul's question: My next issue is if I have to modify the Distribution_name which is shown as an object, How do I assign a new value to it ?


I've set TXDataWebDataset.SubpropsCount=1 and all subfields created OK. Now I wish to modify the object SYSTEMID value.
7

You have to replace it with a full object. Easiest way is to retrieve an object SYSTEMID from the server with ID 45, and then replace the field value.

8
You have to replace it with a full object. Easiest way is to retrieve an object SYSTEMID from the server with ID 45, and then replace the field value.  ???????????

Good morning Wagner;
Thank  you for your explanation, however, can you pretend that I don't know what you are talking about and actually show me how to do it?
Thank you.

9

Sure Steve, sorry about that.

Here is an example. I'm doing a server request asking for the Artist object with id 5.
When the request returns, I just put the retrieved value as the content of field "Artist".



  XDataWebClient1.Get('Artist', 5, procedure(Response: TXDataClientResponse)
    begin
      xdsAlbums.Edit;
      xdsAlbums.FieldByName('Artist').Value := Response.Result;
    end);