Issue
sc_task list loads slowly when sc_req_item.stage field is added on the list view
Cause
The workflow contexts of most of the sc_req_item records is empty, probably due to cloning.
Resolution
- The reason for this behaviour is, there are a lot of RITMs in the instance with their workflow contexts absent.
- The reason behind them being absent is due to cloning of the dev instance from prod, when an instance is cloned, the workflow contexts are not copied over - this is OOB behaviour.
- If these records are filtered out and only query the sc_tasks whose RITMs have workflow contexts present, this issue will not be seen.
