Stages and Flow Designer

[CMartinTN]

I have a custom table that has a reference field for the associated RITM. In Flow Designer, I am trying to update the Stage of the RITM in a Flow that is triggered by a change in the custom table. Changing the value of the Stage field in the RITM doesn't advance the Stage icons for the RITM. Adding a Stage in the actual Flow changes a workflow field in the custom table rather than the RITM record. Any advice on how I can progress the Stage icons for the RITM as a result of either the change to the Stage field in the RITM or as a result of a Stage in the Flow that is triggered by something other than the RITM?

[Soeren Maucher]

Hello @CMartinTN 

the stages of the RITM are defined and set by the flow which is selected under the tab “Process Engine” on the Catalog Item.

As I understand the flow you are trying to update the RITM from is not this specific flow but another one which is triggered based on another custom table.

In my opinion the best approach would be to handle the stages in the corresponding flow (the one selected under “Process Engine”). For instance here you can add a “Wait for” condition which will be based on your custom table or other flow. Basically, you have the two flows connected now.

I hope this helped. If yes, I would appreciate if you could mark this answer as "correct solution". Thank you!

Greetings,

Sören

[CMartinTN · Accepted solution]

Thank you Soeren but we have multiple flows triggered on table changes and it would take a long time to merge them into one flow. That is good information for future development. I did find a way to make it work. I created my own actions to change the stage to various values. I found the Stage State table in another forum post and that proved to be the answer for me. I scripted the Stage Status field in the Stage State table and it worked like a charm. You just identify the ID = requested item, Field = stage, Table = sc_req_item, and then script the Stage Status. 

[Pavan Kumar28]

Hi @CMartinTN ,

could you please brief it how you done.
Regards,
Pavan.

[OleksiyK]

If you feel a bit lost like I do, here is some hint.

Stages is a reference field in the table Flow engine contexts [sys_flow_context].

It refers to a record in the table Stage State [stage_state]. There a JSON is stored in the field "Stage Status", which contains full information about the stage model of this specific flow (copied down on flow start, I suppose), including such attributes as 

"status":"in_progress" or "status":"complete"

"inProgress":true or "inProgress":false

This is where you fiddle to make the flow stage renderer think (and show) what you want it to do.