Report or Script to get RITM number(s) by workflow activity.

[Eric Woody]

So, I have a "Wait for Condition" workflow activity and I want to create a daily email to show what RITM(s) are sitting on that activity. I don't need a lot of information, mainly just the REQ number that it's under. Anyone know what the best way to get this information?

[Brad Bowman · Accepted solution]

Hi Eric,

The wf_executing table is a good place to start.  You can confirm these values in a list view of this table, manually filtered to find the records you're looking for.

• State = waiting (label shows 'Running')
• you can specify a Context.workflow_version, which is the Name of the workflow
• activity.activity_definition.name = Wait for condition
• activity.name, which is helpful if this wait activity has a unique name vs others in the same (or different if you don't specify the context.workflow_version) workflows.

 Once you get the right records, context.id will get you the sys_id of the RITM, so you could use context.id.number to get the RITM Number, and context.id.request.number to get the REQ Number,...

[Eric Woody]

Thank you, Brad. That was exactly what I needed to get me in the right direction. 

[Brad Bowman]

You are welcome!