Query to show me the reached Workflow dates of the projects and requests
I have a query which shows me the dates, when the project reached a status.
SELECT LAST_UPDATE_DATE, STEP_NAME, FROM kwfl_step_transaction_hist_v WHERE TOP_INSTANCE_SOURCE_TYPE_CODE = 'IR' AND CURRENT_FLAG = 'Y' AND TOP_INSTANCE_SOURCE_SET_ID = 30874 ORDER BY step_transaction_history_id;
In this query I get all workflowstatus and -dates for the project (ID = 30874) in a VERTICAL structure. How can I get the result in a HORIZONTAL structure. I tried with the function DECODE but it didn't work.
now I get the result:
last_update_date | step_name
12.01.13 | Projectstart
14.02.13 | SRS Creation
I want to get:
Projectstart | SRS Creation .....
12.01.13 | 14.02.13 .....
Of course I need the results for the projects and requests. that means that I need the project_name, project_id or request_id.