I have a data structure with parent entity and two child entities both connected as a relationship with IsParentChild=true. When the workflow task Update context by Xpath is used to update one of the child entities, the updated entity in the result is on the same level as the parent entity. The other child entity stays the same.
In this case it is a result of suboptimal modelling, since the update deletes the value in the child entity that is used as a relationship key to the parent entity. Still the result should not be as seen bellow.
Input
<ROOT>
<Invoice Id="5a76bf77-1490-4eec-b69f-e32cffa0d939" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2025-05-07T13:54:56.95+02:00" Selected="false" Number="2025150101" BatchId="829366b0-eeb3-4251-a571-3b2c395a6f2f" DateOfTaxableSupply="2024-12-31T00:00:00+01:00" DateOfIssue="2025-05-07T00:00:00+02:00" CustomerPostalCode="473 01" InvoicingPeriodStart="2024-01-01T00:00:00+01:00" SupplierCity="Praha 8 - Dolní Chabry" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" InvoicingPeriodEnd="2024-12-31T00:00:00+01:00" CustomerCity="Nový Bor" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" refInvoiceStatusId="5b594eda-6237-4056-9269-f0717506cd71" DueDate="2025-05-17T00:00:00+02:00" SupplierPostalCode="184 00" VATBase="3674.2000" CustomerStreet="NA" refCustomerId="53c9ab70-a059-4146-80b1-b19f8460443e" TotalPrice="4445.7800" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" RecordUpdated="2025-05-07T13:55:05.213+02:00">
<WeighingTicket IsNoteChecked="false" refWasteCodeId="b1938d7f-41f9-4773-813f-2d841a5ad716" refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" SiteName="Kyje" SupplierPostalCode="184 00" WeightTare="6.6200000000" refInvoiceId="5a76bf77-1490-4eec-b69f-e32cffa0d939" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" refSiteId="d32ef884-9333-4b00-9f58-4e661e0da489" Id="5be4b603-d121-40da-941a-5baf8b074c40" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2025-01-06T10:35:18.003+01:00" Selected="false" refVehicleId="d113b778-3836-4b5d-bf13-4291a0179ff6" CustomerCity="Nový Bor" CustomerTaxID="175-25033882" refPriceListId="58ddec26-5ae2-454b-be13-96a814798ad2" Date="2024-11-19T08:00:00+01:00" refCustomerId="53c9ab70-a059-4146-80b1-b19f8460443e" WeighingNumber="18890" WeightGross="11.3200000000" LicensePlate="3SM8255" WasteReportMunicipality="Praha 14" refSupplierId="44b56a80-9ab0-449e-9e28-c949f1553d28" CustomerPostalCode="473 01" CustomerForWasteExport="53c9ab70-a059-4146-80b1-b19f8460443e" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" UnitPrice="310.0000" ProductName="beton nad 50 cm" TotalPrice="1457.0000" CustomerBusinessID="25033882" CustomerStreet="NA" WeightNet="4.7000000000" refKatastrKodADM="22490426" Number="543" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" WasteCode="17 01 01" WasteReportMunicipalityCode="547361" refWeighingTicketStatusId="5a1afb8d-412b-4f71-979c-80c8a1a05487" RecordUpdated="2025-02-04T20:57:46.8+01:00" />
<WeighingTicket IsNoteChecked="false" refWasteCodeId="0a2d45ea-eb9f-4464-bd6d-a0f51ee93c11" refProductId="4c61a68b-edd1-4739-9b6f-45ec73bbe33f" SiteName="Kyje II" SupplierPostalCode="184 00" WeightTare="7.2600000000" refInvoiceId="5a76bf77-1490-4eec-b69f-e32cffa0d939" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" SupplierTaxID="CZ00196304" refSiteId="d5d6dd4a-cae1-4d78-80bd-f8b6d36a90ad" Id="e7b304e9-58b6-40c9-9f9f-babd6ba40c20" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2024-06-05T17:26:58.233+02:00" Selected="false" refVehicleId="b9956d6b-740b-47af-8052-825b943b120f" CustomerCity="Nový Bor" CustomerTaxID="175-25033882" refPriceListId="58ddec26-5ae2-454b-be13-96a814798ad2" Date="2024-11-13T15:00:00+01:00" refCustomerId="53c9ab70-a059-4146-80b1-b19f8460443e" WeightTareWeighingNumber="18889" WeightGross="16.9000000000" WeightTareDate="2025-01-06T10:34:26+01:00" Weight1Date="2024-06-05T17:26:58+02:00" LicensePlate="6H43597" WasteReportMunicipality="Praha 14" refSupplierId="44b56a80-9ab0-449e-9e28-c949f1553d28" SupplierCity="Praha 8 - Dolní Chabry" CustomerPostalCode="473 01" CustomerForWasteExport="53c9ab70-a059-4146-80b1-b19f8460443e" Weight1="16.9000000000" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" UnitPrice="230.0000" ProductName="sádrokarton" TotalPrice="2217.2000" CustomerBusinessID="25033882" CustomerStreet="NA" WeightNet="9.6400000000" refKatastrKodADM="22490426" Number="507" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" WasteCode="17 09 04" WasteReportMunicipalityCode="547361" refWeighingTicketStatusId="5a1afb8d-412b-4f71-979c-80c8a1a05487" RecordUpdated="2025-01-06T10:36:24.377+01:00" />
<InvoiceItem refProductId="4c61a68b-edd1-4739-9b6f-45ec73bbe33f" refInvoiceId="5a76bf77-1490-4eec-b69f-e32cffa0d939" VATRate="21.0000000000" VAT="465.6100" Amount="9.6400000000" UnitPrice="230.0000" TotalPrice="2682.8100" VATBase="2217.2000" Selected="false" RecordCreated="2025-05-07T13:54:56.953+02:00" Id="7f81c4f4-64e0-4784-8b4a-45a4743522f8" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" />
<InvoiceItem refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" refInvoiceId="5a76bf77-1490-4eec-b69f-e32cffa0d939" VATRate="21.0000000000" VAT="305.9700" Amount="4.7000000000" UnitPrice="310.0000" TotalPrice="1762.9700" VATBase="1457.0000" Selected="false" RecordCreated="2025-05-07T13:54:56.953+02:00" Id="afdb86aa-ac66-4b98-983c-5dc059476dcb" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" />
</Invoice>
<Invoice ContractNumber="8765" Id="1e2787db-b65f-4910-a320-b8d8555ae3e1" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2025-05-07T13:54:56.95+02:00" Selected="false" Number="2025150102" BatchId="829366b0-eeb3-4251-a571-3b2c395a6f2f" DateOfTaxableSupply="2024-12-31T00:00:00+01:00" DateOfIssue="2025-05-07T00:00:00+02:00" CustomerPostalCode="106 00" InvoicingPeriodStart="2024-01-01T00:00:00+01:00" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" InvoicingPeriodEnd="2024-12-31T00:00:00+01:00" CustomerCity=" Praha 10" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" refInvoiceStatusId="5b594eda-6237-4056-9269-f0717506cd71" DueDate="2025-05-21T00:00:00+02:00" SupplierPostalCode="184 00" VATBase="9830.1000" SupplierStreet="Údlická čp. 761/7" CustomerStreet="Práčská 1881/14" refCustomerId="03502163-4741-4a7d-9166-d5431ac8b10f" TotalPrice="11894.4200" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" RecordUpdated="2025-05-07T13:55:26.223+02:00">
<WeighingTicket IsNoteChecked="false" refWasteCodeId="b1938d7f-41f9-4773-813f-2d841a5ad716" Weight1WeighingNumber="18891" refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" SiteName="Na Betonce" SupplierPostalCode="184 00" WeightTare="32.0000000000" refInvoiceId="1e2787db-b65f-4910-a320-b8d8555ae3e1" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" SupplierTaxID="CZ00196304" refSiteId="d0bc423d-7884-4982-a6f2-deaa7f627a6b" Id="ddcc2574-a1eb-4215-8e8f-6ad0f35f5b8c" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2024-11-01T18:52:59.203+01:00" Selected="false" Customer_ContractNumber="8765" refVehicleId="d113b778-3836-4b5d-bf13-4291a0179ff6" CustomerCity=" Praha 10" CustomerTaxID="CZ02251809" refPriceListId="58ddec26-5ae2-454b-be13-96a814798ad2" Date="2024-11-01T18:54:26+01:00" refCustomerId="03502163-4741-4a7d-9166-d5431ac8b10f" WeightTareWeighingNumber="18891" WeighingNumber="18892" WeightGross="63.7100000000" WeightTareDate="2024-11-01T18:52:58+01:00" Weight1Date="2024-11-01T18:52:58+01:00" LicensePlate="3SM8255" WasteReportMunicipality="Praha 16" refSupplierId="44b56a80-9ab0-449e-9e28-c949f1553d28" SupplierCity="Praha 8 - Dolní Chabry" CustomerPostalCode="106 00" ContractNumber="8765" CustomerForWasteExport="03502163-4741-4a7d-9166-d5431ac8b10f" Weight1="98.0000000000" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" UnitPrice="310.0000" SupplierStreet="Údlická čp. 761/7" ProductName="beton nad 50 cm" TotalPrice="9830.1000" CustomerBusinessID="02251809" CustomerStreet="Práčská 1881/14" WeightNet="31.7100000000" refKatastrKodADM="22060430" Number="531" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" WasteCode="17 01 01" WasteReportMunicipalityCode="539601" refWeighingTicketStatusId="5a1afb8d-412b-4f71-979c-80c8a1a05487" RecordUpdated="2025-01-06T10:23:34.367+01:00" />
<InvoiceItem refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" refInvoiceId="1e2787db-b65f-4910-a320-b8d8555ae3e1" VATRate="21.0000000000" VAT="2064.3200" Amount="31.7100000000" UnitPrice="310.0000" TotalPrice="11894.4200" VATBase="9830.1000" Selected="false" RecordCreated="2025-05-07T13:54:56.953+02:00" Id="c5bbb821-84dd-4d96-a01f-050b6d1ca495" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" />
</Invoice>
</ROOT>
Result
<ROOT>
<Invoice Id="5a76bf77-1490-4eec-b69f-e32cffa0d939" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2025-05-07T13:54:56.95+02:00" Selected="false" Number="2025150101" BatchId="829366b0-eeb3-4251-a571-3b2c395a6f2f" DateOfTaxableSupply="2024-12-31T00:00:00+01:00" DateOfIssue="2025-05-07T00:00:00+02:00" CustomerPostalCode="473 01" InvoicingPeriodStart="2024-01-01T00:00:00+01:00" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" InvoicingPeriodEnd="2024-12-31T00:00:00+01:00" CustomerCity="Nový Bor" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" refInvoiceStatusId="5b594eda-6237-4056-9269-f0717506cd71" DueDate="2025-05-17T00:00:00+02:00" SupplierPostalCode="184 00" VATBase="3674.2000" CustomerStreet="NA" refCustomerId="53c9ab70-a059-4146-80b1-b19f8460443e" TotalPrice="4445.7800" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" RecordUpdated="2025-05-07T13:55:05.213+02:00">
<InvoiceItem refProductId="4c61a68b-edd1-4739-9b6f-45ec73bbe33f" refInvoiceId="5a76bf77-1490-4eec-b69f-e32cffa0d939" VATRate="21.0000000000" VAT="465.6100" Amount="9.6400000000" UnitPrice="230.0000" TotalPrice="2682.8100" VATBase="2217.2000" Selected="false" RecordCreated="2025-05-07T13:54:56.953+02:00" Id="7f81c4f4-64e0-4784-8b4a-45a4743522f8" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" />
<InvoiceItem refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" refInvoiceId="5a76bf77-1490-4eec-b69f-e32cffa0d939" VATRate="21.0000000000" VAT="305.9700" Amount="4.7000000000" UnitPrice="310.0000" TotalPrice="1762.9700" VATBase="1457.0000" Selected="false" RecordCreated="2025-05-07T13:54:56.953+02:00" Id="afdb86aa-ac66-4b98-983c-5dc059476dcb" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" />
</Invoice>
<Invoice ContractNumber="8765" Id="1e2787db-b65f-4910-a320-b8d8555ae3e1" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2025-05-07T13:54:56.95+02:00" Selected="false" Number="2025150102" BatchId="829366b0-eeb3-4251-a571-3b2c395a6f2f" DateOfTaxableSupply="2024-12-31T00:00:00+01:00" DateOfIssue="2025-05-07T00:00:00+02:00" CustomerPostalCode="106 00" InvoicingPeriodStart="2024-01-01T00:00:00+01:00" SupplierCity="Praha 8 - Dolní Chabry" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" InvoicingPeriodEnd="2024-12-31T00:00:00+01:00" CustomerCity=" Praha 10" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" refInvoiceStatusId="5b594eda-6237-4056-9269-f0717506cd71" DueDate="2025-05-21T00:00:00+02:00" SupplierPostalCode="184 00" VATBase="9830.1000" refCustomerId="03502163-4741-4a7d-9166-d5431ac8b10f" TotalPrice="11894.4200" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" RecordUpdated="2025-05-07T13:55:26.223+02:00">
<InvoiceItem refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" refInvoiceId="1e2787db-b65f-4910-a320-b8d8555ae3e1" VATRate="21.0000000000" VAT="2064.3200" Amount="31.7100000000" UnitPrice="310.0000" TotalPrice="11894.4200" VATBase="9830.1000" Selected="false" RecordCreated="2025-05-07T13:54:56.953+02:00" Id="c5bbb821-84dd-4d96-a01f-050b6d1ca495" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" />
</Invoice>
<WeighingTicket IsNoteChecked="false" refWasteCodeId="b1938d7f-41f9-4773-813f-2d841a5ad716" refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" SiteName="Kyje" SupplierPostalCode="184 00" WeightTare="6.6200000000" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" SupplierTaxID="CZ00196304" refSiteId="d32ef884-9333-4b00-9f58-4e661e0da489" Id="5be4b603-d121-40da-941a-5baf8b074c40" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2025-01-06T10:35:18.003+01:00" Selected="false" refVehicleId="d113b778-3836-4b5d-bf13-4291a0179ff6" CustomerCity="Nový Bor" CustomerTaxID="175-25033882" refPriceListId="58ddec26-5ae2-454b-be13-96a814798ad2" Date="2024-11-19T08:00:00+01:00" refCustomerId="53c9ab70-a059-4146-80b1-b19f8460443e" WeighingNumber="18890" WeightGross="11.3200000000" LicensePlate="3SM8255" WasteReportMunicipality="Praha 14" refSupplierId="44b56a80-9ab0-449e-9e28-c949f1553d28" SupplierCity="Praha 8 - Dolní Chabry" CustomerPostalCode="473 01" CustomerForWasteExport="53c9ab70-a059-4146-80b1-b19f8460443e" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" UnitPrice="310.0000" SupplierStreet="Údlická čp. 761/7" ProductName="beton nad 50 cm" TotalPrice="1457.0000" CustomerBusinessID="25033882" CustomerStreet="NA" WeightNet="4.7000000000" refKatastrKodADM="22490426" Number="543" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" WasteCode="17 01 01" WasteReportMunicipalityCode="547361" refWeighingTicketStatusId="5a1afb8d-412b-4f71-979c-80c8a1a05487" RecordUpdated="2025-02-04T20:57:46.8+01:00" />
<WeighingTicket IsNoteChecked="false" refWasteCodeId="0a2d45ea-eb9f-4464-bd6d-a0f51ee93c11" refProductId="4c61a68b-edd1-4739-9b6f-45ec73bbe33f" SiteName="Kyje II" SupplierPostalCode="184 00" WeightTare="7.2600000000" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" SupplierTaxID="CZ00196304" refSiteId="d5d6dd4a-cae1-4d78-80bd-f8b6d36a90ad" Id="e7b304e9-58b6-40c9-9f9f-babd6ba40c20" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2024-06-05T17:26:58.233+02:00" Selected="false" refVehicleId="b9956d6b-740b-47af-8052-825b943b120f" CustomerCity="Nový Bor" CustomerTaxID="175-25033882" refPriceListId="58ddec26-5ae2-454b-be13-96a814798ad2" Date="2024-11-13T15:00:00+01:00" refCustomerId="53c9ab70-a059-4146-80b1-b19f8460443e" WeightTareWeighingNumber="18889" WeightGross="16.9000000000" WeightTareDate="2025-01-06T10:34:26+01:00" Weight1Date="2024-06-05T17:26:58+02:00" LicensePlate="6H43597" WasteReportMunicipality="Praha 14" refSupplierId="44b56a80-9ab0-449e-9e28-c949f1553d28" SupplierCity="Praha 8 - Dolní Chabry" CustomerPostalCode="473 01" CustomerForWasteExport="53c9ab70-a059-4146-80b1-b19f8460443e" Weight1="16.9000000000" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" UnitPrice="230.0000" SupplierStreet="Údlická čp. 761/7" ProductName="sádrokarton" TotalPrice="2217.2000" CustomerBusinessID="25033882" CustomerStreet="NA" WeightNet="9.6400000000" refKatastrKodADM="22490426" Number="507" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" WasteCode="17 09 04" WasteReportMunicipalityCode="547361" refWeighingTicketStatusId="5a1afb8d-412b-4f71-979c-80c8a1a05487" RecordUpdated="2025-01-06T10:36:24.377+01:00" />
<WeighingTicket IsNoteChecked="false" refWasteCodeId="b1938d7f-41f9-4773-813f-2d841a5ad716" Weight1WeighingNumber="18891" refProductId="6d0cf6ae-1cf7-4a11-85cd-f5d282b5c825" SiteName="Na Betonce" SupplierPostalCode="184 00" WeightTare="32.0000000000" refWeighingTypeId="8346ec67-911f-4dcb-852f-cbc45b0b2eb1" refSiteId="d0bc423d-7884-4982-a6f2-deaa7f627a6b" Id="ddcc2574-a1eb-4215-8e8f-6ad0f35f5b8c" RecordUpdatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" RecordCreated="2024-11-01T18:52:59.203+01:00" Selected="false" Customer_ContractNumber="8765" refVehicleId="d113b778-3836-4b5d-bf13-4291a0179ff6" CustomerCity=" Praha 10" CustomerTaxID="CZ02251809" refPriceListId="58ddec26-5ae2-454b-be13-96a814798ad2" Date="2024-11-01T18:54:26+01:00" refCustomerId="03502163-4741-4a7d-9166-d5431ac8b10f" WeightTareWeighingNumber="18891" WeighingNumber="18892" WeightGross="63.7100000000" WeightTareDate="2024-11-01T18:52:58+01:00" Weight1Date="2024-11-01T18:52:58+01:00" LicensePlate="3SM8255" WasteReportMunicipality="Praha 16" refSupplierId="44b56a80-9ab0-449e-9e28-c949f1553d28" SupplierCity="Praha 8 - Dolní Chabry" CustomerPostalCode="106 00" ContractNumber="8765" CustomerForWasteExport="03502163-4741-4a7d-9166-d5431ac8b10f" Weight1="98.0000000000" RecordCreatedBy="66a5ca9a-dbed-45b8-8189-c9a3ba4b2b04" UnitPrice="310.0000" SupplierStreet="Údlická čp. 761/7" ProductName="beton nad 50 cm" TotalPrice="9830.1000" CustomerBusinessID="02251809" CustomerStreet="Práčská 1881/14" WeightNet="31.7100000000" refKatastrKodADM="22060430" Number="531" refPaymentMethodId="98557d06-dad6-4834-ae69-4b2203a2d853" WasteCode="17 01 01" WasteReportMunicipalityCode="539601" refWeighingTicketStatusId="5a1afb8d-412b-4f71-979c-80c8a1a05487" RecordUpdated="2025-01-06T10:23:34.367+01:00" />
</ROOT>