3 way comments sync (REQ -> RITM -> SCTASK and vice versa)

[Vishwa Pandya19]

Hello,

We want to create a 3 way comments sync.

If the additional comments are updated on the REQ then they should be cascaded to RITM and the SCTASK.

If the additional comments are updated on the RITM then they should be cascaded to REQ and the SCTASK.

If the additional comments are updated on the SCTASK then they should be cascaded to RITM and the REQ.

We do not want any duplication to occur.

Steps I have tried:

Created 3 separate BR's on each of the tables (before update BR, condition Additional Comment changes, and the script just glide records to the child table, gets the most recent journal entry and updates the child record), and when testing by updating comments on REQ, the comment shows up once on REQ but it show's up twice on RITM and SCTASK.

Is there any other way I can achieve this requirement, without the duplication?

Thanks,

Vishwa

[Jitendra Diwak1 · Accepted solution]

Hi @Vishwa Pandya19,

We should not update anything on Request. we mostly work on RITM and its related Task. Below is solution:

https://www.servicenow.com/community/developer-forum/copy-comments-from-ritm-to-task-vice-versa/m-p/...

Please accept my solution if it works for you and thumps up

Thanks

Jitendra

[Mark Manders]

Add an extra line in your business rules like 'Comment from sc_task + number: ' and exclude that comment from the BR for RITM and REQ and the same for the others. 'comment does not contain ....' should do the trick. 

Do realize that a comment on the REQ, meant for just one RITM, will be reflected on all.