Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Translate the entire conversation x

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

OnurNalbantgl
14-Alexandrite

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