Count of all objects in all object types in Windchill
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Count of all objects in all object types in Windchill
Hi All,
If I want to get the count of all the objects in all object types how would I be getting the same ?
Is there any nested query or program for the same. Please let me know about it
Best Regards,
Aditya
- Labels:
-
General Customization
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
You should take a look on the QueryBuilder / Reports.
Depending on whether you want the count per sub type, you may have to join the table per typedefinition.
Florent
www.4cad.ca
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
How would I get the results if I want to get all the document, part objects, folder count, change request and other objects which can be versionable or non versionable in one single query ?
is it possible for us to have one script for that ?
If yes can you please let me know like how can that be done.
Best Regards,
Aditya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Do you have access to the database? Toad can should you table counts very easily.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Run simple queries against the database for each object type.
For CAD:
select count(*) from epmdocumentmaster to get all unique (e.g. 123.prt, 455.prt).
select count(*) from epmdocument to get all versions (e.g. 123.prt A.1, 123.prt A.2, 123.prt B.1 etc.).
For WTDocuments:
select count(*) from wtdocumentmaster to get all unique
select count(*) from wtdocument to get all versions
For WTParts if used:
select count(*) from wtpartmaster to get all unique
select count(*) from wtpart to get all versions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Mike,
How would I get the results if I want to get all the document, part objects, folder count, change request and other objects which can be versionable or non versionable in one single query ?
is it possible for us to have one script for that ?
If yes can you please let me know like how can that be done.
Best Regards,
Aditya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For this, I'd suggest to query (in Windchill, not directly to the database) as count(*) against wtObject, and then apply Group By to the Object Type. Runs into a bit more but can be done.
May lead to a small consulting gig.
