Forum Discussion

Hargul_Sidhu's avatar
Hargul_Sidhu
Ideator I
2 years ago

How to get the data of Impact Matrix using Query Builder?

Like the question states. I need to get all the items ( their properties etc) that are associated to a PR(which are ECR, ECO etc.)
I also need complete data from the impact matrix of ECO and EDR.

When the Impact Matrix relationship is added to the ECO, the Impact Matrix doesn't have the properties such as item_number, Name, Revision etc. These properties are not even close which makes me think I am not going about this the right way. 
There isn't any other way that I saw to connect the impact matrix to ECO, the only option is via relationship here.

Any help is appreciated!

Thanks!

Impact Matrix
ItemTypes
Properties
Query Builder

1 Reply

  • AngelaIp's avatar
    AngelaIp
    Ideator I
    2 years ago

    Hi,

    the Impact Matrix is just a visualization of the Affected Items table in the background. Unhide the affected Items relationship in your Change process to see. You can use this table in your Query definition. It further connects to Change Control Items which collects all affected Parts, CADs, Documents.

    Angela