sys_hub_flow.definition missing from table

Mark Brogna
Tera Contributor

I am building a business rule that requires identifying the 'yet to be triggered' approvals and tasks for a given flow. From what I have researched I should see a 'definition' field in the 'sys_hub_flow' table but, it appears to be missing.  Does anyone else know where to find these tasks and approvals defined in flow designer?

1 ACCEPTED SOLUTION

  • Scalability 
  • Future investigation if a problem occurs (your logic is in separate places. Flow and BR)
  • Any future enhancements need to take into account two pieces of tech debt
  • The current BR won't take into account that a flow continuing isn't immediate. That BR could update the RITM state before the next flow step starts

View solution in original post

13 REPLIES 13

I would say you're potentially going in the wrong direction.

 

Whats the use case for approvals after a RITM is fulfilled? Are you able to explain the business process you're developing against?

Mark Brogna
Tera Contributor

so I have a series of approvals, follow by a single catalog task. However, as each RITM is in an open state fulfillers can create manual tasks. As such, I need to wait for both the flow task and all the manual tasks to be closed prior to closing the ritm.  If any of the tasks are incomplete, the RITM needs a status of incomplete, otherwise it is complete.

So allowing users to create manual catalog tasks is a deviation from baseline, that's why you're running into this as a pain point.

 

In your flow, after you process-driven activities you could:

  • Use a look up records to find active catalog tasks for the RITM 
  • Use a wait condition on the catalog tasks to wait until it's closed. 

You can put that into a do...until step to re-lookup after the wait condition is fulfilled to recheck if a manual task was created since the last lookup 

 

Mark Brogna
Tera Contributor

I worry about the max iterations for the do ... until and don't want to have a long increment greater than one minute.  In using the lookup records and then having a wait condition in the for each loop, I am not sure how to bubble out the task states ... i.e. incomplete or complete.

Your do until doesn't need to be time based, because the "wait for condition" within the do...until will halt until the record it is watching is updated. 

 

In terms of setting overall RITM state, you can do after this looping process by looking up all the catalog tasks where state is incomplete, and do a max results of 1. If 1 record is found, you know to set the RITM state to incomplete