QML Report listing all WTParts with associated AML AVL info across all Contexts

[AP_11420411]

Version: Windchill 12.0

Use Case: Using a Query Builder report (QML), how can we extract a complete list of all WTParts and their associated AML and AVL details across all Products and Libraries?

Description:

Using a Query Builder report (QML), how can we extract a complete list of all WTParts and their associated AML and AVL details across all Products and Libraries?

[Fadel]

Take  a look at below articles for reference 

https://www.ptc.com/en/support/article/CS40399

https://www.ptc.com/en/support/article/CS210102

[AP_11420411]

Thanks, Fadel.

Is it possible to extract a single report that lists all WTParts along with their associated AML and AVL details across all Products and Libraries?

So far, we have only been able to identify separate QML reports—one for WTParts with AMLs and another for WTParts with AVLs—but not a combined AML/AVL report for a part in a single view.

Could you please advise if this is feasible using QML report and, if so, the recommended approach?

[Marco_Tosin]

Have you read the second article that Fadel mentioned?

The report searches both the AML and AVL tables but includes a filter that excludes WTParts of this type.

Just remove that filter, and you'll get what you're looking for.

[avillanueva]

You can use this QML and make necessary modifications. The list got very large so I had to limit it to more recent parts. I have included PartsLink information and BOM usage as a criteria. My intent was to focus on things that are actually called out on BOMS as priority.