Flow Designer wait for catalog tasks to close before updating Requested Item

Michelle89 · ‎09-18-2020

Hello there!

Hoping to see if anyone has any thoughts on how to make this work in Flow Designer, ( maybe a Custom action or subflow). I have created this Flow that is scheduled to trigger on a monthly basis, and steps 5-7 are not working out for me.

Step 2 - creates a REQ
Step 3 - look up datacenter records (let’s say there are 10)
Step 4 - For the 10 datacenters found
Step 4.1 - Create a RITM
Step 4.2 - Do the following (create 3 SCTASKs and associate to the RITM above)

After all the tickets are created
Step 5 - 7 Lookup any of the subtasks created in Step 4.2, when there is a change: State = Closed Complete. Check the other Catalog Tasks that share the same RITM. When all Catalog Tasks that share the same RITM are State = Closed Complete, update the related RITM in step 7.

Anybody have ideas to make Steps 5-7 work with a different configuration?

Thanks in advance!

DirkRedeker · ‎09-19-2020

Hi

Yes, this is absolutely possible.

One thing, that I personally learned from my experience, was that I needed to split up my requirements into smaller chunks of work.

For your case, I recommend to split the waiting for closing your SC Tasks from the Flow and put a matching logic into a BR.

The solution might look like this:

> For the creation of your RITMs and Tasks, keep your Flow.

> Cut out the waiting portion from the Flow and replace that logic like explained in the next steps

> create a BR, which runs AFTER UPDATE on the sc_task table.

> inside that BR, only trigger the BR when the state of the Task changes to closed

> inside the BR, GlideRecord to check, if there is another Task for the SAME RITM, where the CURRENT task is attached to.

> if yes, set the RITM to closed as well.

That is quite simple and straigh forward.

If you need support in creating the BR, let me know. I can create the example for you. Or you take that challenge yourself.

Let me know, if that answers your question and mark my answer as correct and helpful.

Have fun and Enjoy

BR

Dirk

View solution in original post

WillyWally · ‎03-12-2021

Hello Dirk

I am new to Business Rules, can you provide an example of a business rule for closing the RITM when ALL associated tasks were closed? My exact use case is modeled after the example above.

Thanks

Jay

Anisha4 · ‎04-19-2021

The flow should absolutely work in this case and dont go for a business rule as the RITM might get closed if next task is created with a delay after the business rule is run.

Vk0911 95 · ‎06-28-2022

Can you share the BR If possible.?