Flow Designer Stage Issue

[Divya13]

I have an issue in Flow designer stages.

Below is the scenario:

I have built an simple  custom app and have extended below tables. (I had to extend as we had to add some additional attributes that were not allowed in base tables)

1. sc_request

2.sc_req_item

3.sc_task

4.sc_cat_item

Application is working fine as expected except the performance issues in the list view on the new extended RITM table.

Whenever I add the stage field to list view of this new table it takes forever to load. Almost 5 minutes though i have less than 100 records in total. But if I remove the stage field in list view it loads in couple of  seconds. 

Does any one has come across this performance issue?

Any suggestions or advices are welcome.

[Clara Lemos]

Hi @Divya13 ,

This two articles might be helpful 🙂 

- Modifying 'Workflow Stage' field from Graphical to Text - Support and Troubleshooting (servicenow.co...

- sc_task list loads slowly when sc_req_item.stage field is added on the list view - Support and Troub...

If that helps please mark my answer as correct / helpful!
And if further help is needed please let me know

Cheers

[Divya13]

Thanks Clara for the response. In my case:

1. All the requests are created after cloning.

2. My issue is with extended RITM table and I am using flows instead of workflows.

3. I tried to limit for this  week request which I am sure had flows and that was around 20. But still I see the performance issue and no improvement

[Clara Lemos]

Hi @Divya13 ,

Would you consider change the field type to string? You should still be able to see the stage, maybe not as nice as the before visualisation, but with a better performance 

You'll get something like this