topic Re: QML Report listing all WTParts with associated AML AVL info across all Contexts in Windchill

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

AP_11420411 — Wed, 01 Apr 2026 05:39:12 GMT

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?

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

Fadel — Wed, 01 Apr 2026 05:58:58 GMT

Take a look at below articles for reference

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

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

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

AP_11420411 — Wed, 01 Apr 2026 06:07:23 GMT

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?

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

Marco_Tosin — Wed, 01 Apr 2026 06:19:33 GMT

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.

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

avillanueva — Wed, 01 Apr 2026 11:07:21 GMT

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.