How can I list the number of parts in ECN with query Builder?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How can I list the number of parts in ECN with query Builder?
I want to report the number of objects in ECN.
I want to make this count if possible. Is it possible? I did something similar, but it doesn't give numbers and also writes objects over and over again.
Solved! Go to Solution.
- Labels:
-
CAD Data Mgmt
- Tags:
- change management
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
When you say objects in ECN - do you mean Resulting Objects?
Maybe you can adapt the QML here: https://www.ptc.com/en/support/article/CS313295?source=search
You can get a count by using the database function "count". See: https://support.ptc.com/help/wnc/r12.1.1.0/en/index.html#page/Windchill_Help_Center/querybuilder/QBSelectOrConstrainDatabaseFunction.html
You'll need to put an argument for what to count. Below will count the number of Change Notices. You'll need to change it to be the objects on the ECN. The Persist Info.Object Identifier.Id attribute is really useful because it's distinct for each object.
Hope that helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
When you say objects in ECN - do you mean Resulting Objects?
Maybe you can adapt the QML here: https://www.ptc.com/en/support/article/CS313295?source=search
You can get a count by using the database function "count". See: https://support.ptc.com/help/wnc/r12.1.1.0/en/index.html#page/Windchill_Help_Center/querybuilder/QBSelectOrConstrainDatabaseFunction.html
You'll need to put an argument for what to count. Below will count the number of Change Notices. You'll need to change it to be the objects on the ECN. The Persist Info.Object Identifier.Id attribute is really useful because it's distinct for each object.
Hope that helps!
