Avatar

Correct answer by
Community Advisor

Hi David,

 

Depending of your installation, but the way you want do it should not work in a mid-sourcing configuration.

Not sure to have a best solution, but here what you can try (and not tested so may not work...).

Can you add 2 attributes in your cus:goals schema : recipient-id and service-id ? You put the recipientId and the serviceId into when you registrer the recipient to the service.

Also, join the "nms:subscription" with the 2 keys :

<element ...target="nms:subscription"><join xpath-dst="@recipient-id" xpath-src="@recipient-id"/><join xpath-dst="@service-id" xpath-src="@service-id"/></element>

This way, you should be able to find the "cus:goals" into the subscription delivery (the template) with the native data loading query.

 

Also, I suggest you to never use a SQL query to insert data from a webApp, or at least, escape the string "stringColumns" and "stringValues" (if I were you, I'll use the xtkSession.Write method instead).

 

Don't know if it help ?

Good luck.

 

Cedric

View solution in original post