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
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
Impressive! Thank you.
ReplyDelete