How to validate RITMs in Order Guide Based on their State

[win b]

Hi There,

Can someone help me on this. I know this is easy task but im a little bit confused and i dont know were to start at. So basically i have an Order Guide Setup and from that i declared 3 Catalog in my Order Guide. Then on my REQ here is the following i needed.

When the REQ is created it will generate 3 RITMs based on the 3 catalogs i put in the Order Guide (Catalog1, Catalog2, Catalog3). Then i created  WF and implement it to my Order Guide (which is i dont know if this is working) and from that WF i created a checker for each RITMs if there is a Closed Complete, Closed Incomplete, Closed Skipped RITMs states, and from that point this will be my checker.

1 Closed Complete & 2 Closed Incomplete = REQ Closed Incomplete
2 Closed Complete & 1 Closed Incomplete = REQ Closed Incomplete

1 Closed Complete & 2 Closed Skipped = REQ Closed Complete

2 Closed Complete & 1 Closed Skipped = REQ Closed Complete

3 Closed Complete = REQ Closed Complete

3 Closed Incomplete = REQ Closed Incomplete

3 Closed Skipped = REQ Closed Complete

1 Closed Complete & 1 Closed Incomplete & 1 Closed Skipped = REQ Closed Incomplete

[Sumanth16]

Hi @win b ,

Please refer to below thread:

https://www.servicenow.com/community/developer-forum/update-req-based-on-ritm-state-and-stage/m-p/26...

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[win b]

@Sumanth16 

The table in BR should be in SC_REQUEST or in SC_REQ_ITEM?

[Sumanth16]

Hi @win b ,

Create after business rule on RITM table 

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[win b]

@Sumanth16 

i tried the following and its not working.