Wednesday 4 November 2015

Extracting Task Views from F9000 & F9001 using SQL Query - Oracle ONLY

I cam across a nice way to extract task view using back end SQL query.

select connect_by_root trparnttsk base,
LEVEL, trrltype, trprsseq, trparnttsk,
(select tmlngtask from  prodctl.f9000 where tmtaskid = trparnttsk) pardesc,
trchildtsk,
(select tmlngtask from prodctl.f9000 where tmtaskid =trchildtsk) childdesc,
(select tmobnm from prodctl.f9000 where tmtaskid =trchildtsk) ObjectName,
(select tmver from prodctl.f9000 where tmtaskid =trchildtsk) Version
from prodctl.f9001
START WITH trchildtsk= "Enter Base Child Task ID"
connect by prior trchildtsk=trparnttsk
ORDER SIBLINGS BY trprsseq;

This is the fastest way to extract data

1 comment: