| || |
Need help to retrive Trace_From requiement name
I have requirement(10840). Another requirement is linked in Trace From for this requirement. I need to find requirement details along with Trace From requirement name.
Following Query returns Trace_From requirement number. I need to get the Trace from requirement name instead of number. Can anyone help on this.
select connect_by_root rq_req_name as folder, sys_connect_by_path(rq_req_name, '\')||'' as pfad_req, rq_req_id as req_id, rq_father_id as req_father,REQ_TRACE.RT_FROM_REQ_ID as TRACE_FROM
from REQ r
LEFT JOIN REQ_TRACE
start with rq_req_id = 10840
connect by prior rq_req_id = rq_father_id