Forum Discussion

angela's avatar
angela
Catalyst II
3 years ago

How to update keyed_name of relationship item reliable after new related item was added?

Hi community, I have a custom Document item type that is connected to the regular Part like this: Part  (Source ItemType) - MyPartDoc  (Relationship ItemType) --- MyDocument    (Related ItemTyp...
alaxala's avatar
alaxala
Creator III
3 years ago

I don't know where it is located and what the code looks like that updates the keyed_name according to the Keyed Name Order. At least I did not find anything similar among the SQL stored procedures. I think that this code has nowhere to take information but only from the AML request passed to it.

It can receive AML like this from the browser for example

[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:fcfe0260-f9cc-4aa1-bfb0-e90bd00b9f48:type=xml&text=%3CItem%20type%3D%27Part%27%20action%3D%27update%27%20id%3D%27AAA...AAA%27%3E%0D%0A%20%20%3CRelationships%3E%0D%0A%20%20%20%20%3CItem%20action%3D%27add%27%20type%3D%27MyPartDoc%27%3E%0D%0A%20%20%20%20%20%20%20%3Crelated_id%20keyed_name%3D%22DOC-100001%22%20type%3D%22MyDocument%22%3E%0D%0A%20%20%20%20%20%20%20%20%20%20%3CItem%20type%3D%22MyDocument%22%20typeId%3D%22BBB...BBB%22%20id%3D%22CCC...CCC%22%3E%0D%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Cconfig_id%20keyed_name%3D%22DOC-100001%22%20type%3D%22MyDocument%22%3ECCC...CCC%3C%2Fconfig_id%3E%0D%0A%20%20%20%20%20%20%20%20%20%20%20%20...%0D%0A%20%20%20%20%20%20%20%20%20%20%3C%2FItem%3E%0D%0A%20%20%20%20%20%20%3C%2Frelated_id%3E%0D%0A%20%20%20%20%3C%2FItem%3E%0D%0A%20%20%3C%2FRelationships%3E%0D%0A%3C%2FItem%3E]

or something like this generated by code

[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:b0a9a12b-d132-4415-bfa2-a43b35a1e053:type=xml&text=%3CItem%20type%3D%27Part%27%20action%3D%27update%27%20id%3D%27AAA...AAA%27%3E%0D%0A%20%20%3CRelationships%3E%0D%0A%20%20%20%20%3CItem%20action%3D%27add%27%20type%3D%27MyPartDoc%27%3E%0D%0A%20%20%20%20%20%20%20%3Crelated_id%3ECCC...CCC%3C%2Frelated_id%3E%0D%0A%20%20%20%20%3C%2FItem%3E%0D%0A%20%20%3C%2FRelationships%3E%0D%0A%3C%2FItem%3E]

Both variants are valid and will work. Maybe in the first case this code can fill MyPartDoc keyed_name with the MyDocument keyed_name and in the second it can't.

  • alaxala's avatar
    alaxala
    Creator III
    3 years ago

    No, I was wrong. I tested and in both cases the keyed_name is set to id.

  • alaxala's avatar
    alaxala
    Creator III
    3 years ago

    Hmm.. But after I EDIT exisiting relationship

    [embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:4fa33a36-620e-430b-a6f9-6089f3468b6d:type=xml&text=%3CItem%20type%3D%27Part%27%20action%3D%27update%27%20id%3D%27AAA...AAA%27%3E%0D%0A%20%20%3CRelationships%3E%0D%0A%20%20%20%20%3CItem%20action%3D%27edit%27%20type%3D%27MyPartDoc%27%3E%0D%0A%20%20%20%20%20%20%20%3Crelated_id%3EDDD...DDD%3C%2Frelated_id%3E%0D%0A%20%20%20%20%3C%2FItem%3E%0D%0A%20%20%3C%2FRelationships%3E%0D%0A%3C%2FItem%3E]

    the keyed_name became correct.

    I don't know how useful this information is, but for some reason that's how it works