Stage and state on sc_req_item

[ritaaudi]

Hi: If I create a new workflow on sc_req_item table and look at the Stages in the workflow properties, I see the following: Request Approved, Waiting for Approval, Fulfillment, Delivery, Request Cancelled, Completed. I read that these come from the Stage choices on sc_req_item and wf_stage_default. I don't see 'Request Approved' in either of those tables. Where is that coming from? Also how does the state field on sc_req_item get populated. I can't seem to find the right business rule. Thank you for your help!

[Shane J]

Stages are pulled from Stage Set (stage_set).  The one you mentioned is there by default in my dev instance.

Not sure what you mean about 'State'.  You'd likely be setting that via workflow.

[supriya29]

Hi,

1. You can see the stage set for Request Approved in Stage Sets -> Requested Item.

2. To set the state of sc_req_item, it uses OOB workflow.

     1. Item Designer - Approvals

      2. Item Designer - generate approvals for current sequence

[ritaaudi]

Thank you; I see the stage set. However, I'm still not clear where the state is getting updated from the stage on sc_req_item. I looked at the workflows you mentioned. Can you point me to which activity box in the workflow updates the state?

[ritaaudi]

say I add a new stage on the requested Item Stage set, where do I go to map it to the correct state? Thanks!