- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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