I'm trying to insert records in 'trackingLogRcp' table (since we need to insert external feedbacks) via Update table but at the same time I need that the related UrlInfo table must be populated in this way
[url/@id] = don't care, but it must be connected to the event I want to insert in 'trackingLogRcp'
[url/@label] = custom_value1
[url/@type] = custom_value2
If I try to do it in a single Update data I receive errors.. how should I proceed ?
It's not a good practice to update or insert data in broadlog or trackingLog (Adobe Staff Advice).
It's better to create a table link to recipient to bring back your tracking. You can too create agregage to avoid 0-n relation.
Same for historical delivery.
After, you can do queries on this new table easily.
Could you guide more on "create a table link to recipient to bring back your tracking".
like which link attribute required .