Flow Stages table?

Adam Peterson
Kilo Sage

I am noticing when I change the stage from the Update Record action that I have multiple records of the same name. I would love to clean this up but I am having a hard time finding where these records live.

AdamPeterson_0-1712858554950.png

 

Anybody know?

3 REPLIES 3

Astik Thombare
Tera Sage

Hi @Adam Peterson ,

 

Please right click on Stage Field on sc_req_item form and click on Configure Dictionary 

 

AstikThombare4_0-1712859867291.png

 

Following Form will open 

 

AstikThombare4_1-1712859922774.png

Scroll Down and go to Choices Related List 

 

 

AstikThombare4_2-1712859990223.png

 

From here you can clean duplicate choices -

 

AstikThombare4_3-1712860025533.png

 

if my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful." This action benefits both the community and me.

 

Thanks,

Astik

 

 

 

 

Astik,

Thanks for your reply. I checked my instance and went to choices and only see 1 instance of Completed. Yet in Flow Designer, I have 4 records of Completed. It must be pulling from somewhere else. 

James Chun
Kilo Patron

Hi @Adam Peterson,

 

I believe the lists are generated from 2 tables, one for Workflow stages and one for Flow stages. 

  • Workflow Stages [wf_stage]
  • Flow Stages [sys_hub_flow_stage]

If you look at the records in the tables, you will see that there are records with the same 'Label' but with different 'Value'. Hence you are seeing the same in the choice list within the Flow action.

 

It would be a lot of effort to clean these up as you will have to update all the Workflows/Flows that are using the duplicate stage values. Also, this may cause some issues with reporting or other functionalities as you are changing the value of the stage (even though the label is the same). So, unless something is broken, I wouldn't recommend changing it right way but maybe changing one at a time in the future.

 

Additionally, I would recommend changing the stage via 'Add a Stage' functionality in the Flow designer.

e.g.

JamesChun_0-1712870056799.png

https://docs.servicenow.com/bundle/washingtondc-build-workflows/page/administer/flow-designer/task/a...

 

Cheers