Requirements to Scope Item linkage - is there a table?
In ALM 11.5, I want to programatically work with the requirements associated with a scope item. I see that there are linkage tables for scope items to milestones, reqs to requirements, etc. but I can't find a table that stores the linkage from the requirement to the scope item. I am assuming that is how the information is stored. Can someone help me out with this?
Scope Items link to Releases and Miestones links to the Releases table as well (MS_RELEASE_ID = RELEASES.REL_ID) ... the QPM_KPI table joins both Scope Items and Milestones (KPI_OWNER_ID = QPM_MILESTONES.MS_ID) and ( KPI_DEFINITION_ID = QPM_KPI_TYPES.KPIT_ID )
Requirements link to target cycle which link to releases via Release_Cycles ....
ALM does calculations and store the results in the calculations table. Are you trying to calculate to show scope items and KPI calculations yourself?
What my friend Sal really meant to say was that you can find requirements linked to a scope item in the db with the following query:
(select req.RQ_REQ_ID, req.RQ_REQ_PATH
from td.QPM_SCOPE_ITEM si, td.content_definitions cd, td.CONTENT_ROOTS cr, td.REQ
where si.SCI_ID = cd.COD_PARENT_ID
and cd.COD_PARENT_TYPE = 'QPM_SCOPE_ITEM'
and cd.COD_ID = cr.CRT_CONTENT_ID
and cr.CRT_ROOT_ENTITY_TYPE = 'REQ'
and cr.CRT_ROOT_ENTITY_ID = req.RQ_REQ_ID) si
where LEFT(req.RQ_REQ_PATH,LEN(si.rq_req_path)) = si.RQ_REQ_PATH
of course, you can build upon this to find other linkages such as tests and test sets, but this should get you started down the path to success...