Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Insert records in 'trackingLogRcp'

salvdangelo
Level 5
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
christophec3473
Level 2
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

yashdeepm784504
Level 2
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,