Highlighted

Insert records in 'trackingLogRcp'

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

30-11-2017

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

Replies

Highlighted

Avatar

Avatar

david_garcia1

MVP

Avatar

david_garcia1

MVP

david_garcia1
MVP

01-12-2017

paste the errors

Highlighted

Avatar

Avatar

christophec3473

Avatar

christophec3473

christophec3473

15-12-2017

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

Highlighted

Avatar

Avatar

yashdeepm784504

Avatar

yashdeepm784504

yashdeepm784504

22-01-2019

Hi Christophe

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

like which link attribute required .

Thanks,