Insert records in 'trackingLogRcp'

[salvdangelo]

Hi,

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 ?

Salvatore

Jean-Serge Biron​

Adhiyan​

@nkur​

kirti.rawat​

[david--garcia]

paste the errors

[christophec3473]

Hi,

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.

Christophe

[yashdeepm784504]

Hi Christophe

Could you guide more on "create a table link to recipient to bring back your tracking".

like which link attribute required .

Thanks,