Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

Insert records in 'trackingLogRcp'

Avatar

Level 5

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

3 Replies

Avatar

Level 2

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

Avatar

Level 2

Hi Christophe

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

like which link attribute required .

Thanks,