QML report for incomplete work Items from Change Task with the respective CT, ECN and ECR number

[BikrantS]

Version: Windchill 12.0

Use Case: I am trying to build a windchill report to extract all the incomplete work items from a change task with the respective Change Task, ECN and ECR numbers.

Description:

The report which i have build is able to extract the Change Task, ECN however its unable to report all the ECRs against the ECNs. There are many cells empty in the ECR column. Whereas when i navigate to the ECN in windchill i can see the related ECR.

I have attached the QML report i am using to extract the data. Please could you suggest why i have empty cells in ECR number column. 

Thanks

[Marco_Tosin]

There are dozens of PTC support articles with ready-to-use reports or explaining the basics of linking DB objects together.

Below is a list of articles that might help you build your own report.

Understanding Change Management objects and their relations in Windchill PDMLink

[QML] Report listing all Change Requests with/without an associated Change Notice in Windchill PDMLink

"QML Report" that shows all "Change Notices", "Change Tasks" with "Resulting objects" along with any underlying "Change Requests" and "Problem Reports" (if they exist) in Windchill PDMLink

How to link work items of Change Request to Change Requests, Change Notices and Change Tasks in Report Builder in Windchill PDMLink

QML attached - outstanding change work items with related change objects

[anursingh]

Hi @BikrantS,

I wanted to follow up with you on your post to see if your question has been answered. 
If so, please mark the appropriate reply as the Accepted Solution. 
Of course, if you have more to share on your issue, please let the Community know so that we can continue to help you. 

Thanks,
Anurag