Skip to main content
olivierlp
olivierlpCommunity Manager
Community Manager
April 3, 2026
Question

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

  • April 3, 2026
  • 2 replies
  • 16 views

Initially posted by @AP_11420411 on April 1,2026

 

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?

 

This topic and some replies were published during the recent read-only period. We have manually republished the missing posts to preserve the integrity of the conversation. Learn more.

April 3, 2026

The Community team

2 replies

olivierlp
olivierlpCommunity ManagerAuthor
Community Manager
April 3, 2026

Initially posted by ​@Fadel on April 1,2026

 

Take  a look at below articles for reference 

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

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

 

Fede

Olivier
olivierlp
olivierlpCommunity ManagerAuthor
Community Manager
April 3, 2026

Initially posted by @AP_11420411 on April 1,2026

 

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?

 

Olivier
olivierlp
olivierlpCommunity ManagerAuthor
Community Manager
April 3, 2026

Initially posted by ​@Marco_Tosin on April 1, 2026

 

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.

 

AML_AVL.png

 

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

 

AML_AVL_1.png

 

Marco

Olivier
olivierlp
olivierlpCommunity ManagerAuthor
Community Manager
April 3, 2026

Initially posted by ​@avillanueva  on April 1,2026

 

 

2026-04-01 07_06_46-ScanSnap Home.pngYou 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. 

 

Olivier
Terms & ConditionsCookie settingsAccessibility statement