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'

Avatar

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
salvdangelo
Level 4

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

Avatar

Avatar
Coach
MVP
david_garcia1
MVP

Likes

106 likes

Total Posts

183 posts

Correct Reply

41 solutions
Top badges earned
Coach
Contributor
Shape 1
Give Back 25
Give Back 10
View profile

Avatar
Coach
MVP
david_garcia1
MVP

Likes

106 likes

Total Posts

183 posts

Correct Reply

41 solutions
Top badges earned
Coach
Contributor
Shape 1
Give Back 25
Give Back 10
View profile
david_garcia1
MVP

01-12-2017

paste the errors

Avatar

Avatar
Boost 5
Level 2
christophec3473
Level 2

Likes

10 likes

Total Posts

8 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 3
View profile

Avatar
Boost 5
Level 2
christophec3473
Level 2

Likes

10 likes

Total Posts

8 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 3
View profile
christophec3473
Level 2

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

Avatar

Avatar
Validate 1
Level 1
yashdeepm784504
Level 1

Likes

2 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
yashdeepm784504
Level 1

Likes

2 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
yashdeepm784504
Level 1

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,