Unable to select the stages that are added using Flow when creating a report in Requested item table

[ryan69]

Unable to select the stages that are added using Flow when creating a report in Requested item table.

When you create a flow and added custom stages which are specific to clients, the RITM created using the

catalog items are updated with the stages, however when you try to create a report on the table sc_req_item,

the stages are not found, so you cannot use it to filter and build a report.

Troubleshooting done:

1. Created the test catalog item and flow that includes stages
2. Submit sample request
3. Create a report using the stage in ritm table

Screenshots:

[ryan69]

Thanks a lot for suggesting a workaround. Appreciate that you simulated this as well.

So we can conclude that there is no support for stages coming from flow designer.

I think it will not be as easy when end user will be the one to create the report or perform a query, this is our main concern. Unless the dashboards or reports are already created for them.

[Praveen Mariapp]

The stages created in the flow are created in the table 'sys_hub_flow_stage' and mapped to the specific flow in which it was created.

If the stage needs to be appearing in the reports, then the stage has to be created in the 'sys_choice' table for the RITM table.

Hope this information helps.