Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Unique Identifier of Email

Avatar

Level 2

Hi,

 

Does ACC have unique Identifier of an email?

 

For example, If Person 'A' and Person 'B' received both email 'X' and 'Y', there is 4 unique identifiers for each email & person(email address) combination.

1 Accepted Solution

Avatar

Correct answer by
Level 9

Hi @gnals12 - The broadLog primary key (@id) is the unique identifier for a message created in ACC. Every message created (including control, seeds and proofs) will have a unique broadLog identifier. You can find it in the nms:broadLogRcp table.

Cheers

Darren

View solution in original post

3 Replies

Avatar

Correct answer by
Level 9

Hi @gnals12 - The broadLog primary key (@id) is the unique identifier for a message created in ACC. Every message created (including control, seeds and proofs) will have a unique broadLog identifier. You can find it in the nms:broadLogRcp table.

Cheers

Darren

Avatar

Level 2
Hi Darren, Is there a possibility broadLog primary key(@id) can be reused after Log is cleaned? We want to avoid a situation that the same unique identifer pops up in different message few years later.

Avatar

Level 9
Hi @gnals12. If you just delete the data in the BroadLog then the primary key will continue where it left off. Its a database sequence and will continue to increase unless you reset it (usually not recommended). Unsure why you want to "clean" the BroadLog. It should be regularly purged as part of the normall instance configuration. You can set the BroadLog history in the configuration. Cheers Darren