Work items imported from Jira and their connection to the release

[kchadwick]

We are currently using the Jira integration inside of digital product release. When using this integration Jira stories are brought over as work items. I am wondering if anyone has found out how the work items are being linked to the DPR release. I have found several tables that work with the Jira integration and are being populated but I cannot find a dot walk path from work items back to the release or any other table used in the Jira integration. Any help on this matter would be great.

[kchadwick]

This is exactly what we did. I see the table sn_devops_plan_version where the version is created. However, I do not see how this version gets connected to the DPR release or DPR version (cmdb_software_component_model). There is a release field on the sn_devops_plan_version table but it is not filled out. I am trying to find the correct path to get all work items related to a release. For example, with product enhancements there is a field on the table linking back to the release which makes it easy to query all product enhancements on a release.

[kchadwick · Accepted solution]

It looks like I have found the table I needed. This relates the two versions together (The plan version and the DPR release version). From this table I should be able to successfully find the link of work item to DPR release. 

sn_devops_m2m_plan_version_software_model