Hi Colin,
It does work. I've replicated using the REST API, see my screenshots. Whenever dealing with child objects do not include the parent object. The format is <relationship name>.<attributename>.
Could the be something wrong with the relationship query. If in doubt run the query like in the case:
Select * from doclinks where <relationship query>;
------------------------------
Regards,
Craig Kokay
ISW
Maximo Practice Manager
eMail:
ckokay@isw.net.auPhone: +61-411-682-040
#IBMChampion2022
------------------------------
Original Message:
Sent: 07-08-2022 15:59
From: Colin Aitchison
Subject: Problems with retrieving the child objects with the REST API
Hello all,
Trying to query child objects using REST in MXLoader. The parent object is JOBPLAN and the Child object is DOCLINKS. My query in MXLoader is JPNUM="J1013". This returns the parent object, but none of the child object attributes which are detailed in below screenshot. The highlighted column shows the Parent object, with the relationship name and operator. We also tried RELATIONSHIP NAME and OPERATOR and no result DOCLINKS{ADDINFO}
If we use OS and Native authentication the results are returned for the child object.
------------------------------
Colin Aitchison
Regional Municipality of York
------------------------------