Project and Portfolio Management Practitioners Forum
cancel

Step Status of a Request

SOLVED
Go to solution
Highlighted
b460
Super Contributor.

Step Status of a Request

Hi,

Does anyone know which table in the database the "step status" of a request is kept?

I need to create a query that selects all requests at a certain step but cant seem to work it out by following the data model.

Thanks,
B.
8 REPLIES
Mahen M
Acclaimed Contributor.

Re: Step Status of a Request

Hi,
The table name is 'KWFL_step_transactions'

Select * from KWFL_step_transactions where workflow_step_id=38449 and Status='ERROR'

Instance_Source_id gives the Request ID.

Regards,
Mahendran M
b460
Super Contributor.

Re: Step Status of a Request

What about the name of the step status?
Mahen M
Acclaimed Contributor.

Re: Step Status of a Request

You can use the Workflow Step ID instead of step status.

Regards,
Mahendran M
b460
Super Contributor.

Re: Step Status of a Request

I actually need to retrieve the step status names.

For example: Not Submitted, Reviewed, Deferred etc etc

Any ideas where they are stored in the database and how I can link them to a request?
Mahen M
Acclaimed Contributor.

Re: Step Status of a Request

Do you mean to ask the output data like this

Request ID Status Name
100001 In Requirements
100002 Not Submitted
100003 Closed

Like this?

Regards,
Mahendran M
b460
Super Contributor.

Re: Step Status of a Request

Hi,

Yes exactly like that.
Mahen M
Acclaimed Contributor.
Solution

Re: Step Status of a Request

Select R.Request_ID, S.Status_name from kcrt_Requests R, KCRT_STATUSES S where R.Status_id=S.Status_id and R.Request_id=91625


Hope the above Query Helps.

Regards,
Mahendran M
b460
Super Contributor.

Re: Step Status of a Request

Thanks,

Exactly what I was looking for.