07-03-2013 08:37 AM
I have a query which shows me the dates, when the project reached a status.
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.
Thank you for your help.
Solved! Go to Solution.
07-03-2013 10:22 PM
With SQL alone it will be little challenging. You can do this easily in PL/SQL.
I found this site useful to get it done via SQL alone, you can refer it.
Hope this help.
-- Remember to give Kudos to answers! (click the KUDOS star)