
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
from
td.req,
(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...