cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

How can I list the number of parts in ECN with query Builder?

OnurNalbantgl
13-Aquamarine

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.

 

 

OnurNalbantgl_1-1708092905636.png

 

ACCEPTED SOLUTION

Accepted Solutions

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. 

joe_morton_0-1709044738722.png

Hope that helps!

 

View solution in original post

2 REPLIES 2

Maybe this article can help you.

 

Report for counting the Affected Objects in a Problem Report

 

 

Marco

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. 

joe_morton_0-1709044738722.png

Hope that helps!

 

Announcements


Top Tags