cancel
Showing results for 
Search instead for 
Did you mean: 

Build a Query for searching parts with status in an assembly

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hello all TC-Experts,I hope you can help me with this.

 

I´ve got a scenario for searching all of the itemrevisions in only an Assembly which has "Release" Status.

Example:

I would like to find all Itemrevision with release status in a assembly part named "Fernsehturm" 

also i´ve built some query:

In the Query builder select base class: Item Revision

To find item revisions with a specific release status: "release_status_list.name = Released"

 

The search result has shown all Itemrevisions with "Released" status form all of products what i have in my database, but not only from "Fernsehturm" as attachment.

 

has anyone ideas or experiences which attribute has to be used to solve this situation?

PS. I´m using TeamCenter 10.1.5.1

8 REPLIES

Re: Build a Query for searching parts with status in an assembly

Phenom
Phenom

I tried to do the same, but failed.

 

An option other than Query Builder is to open "Fernsehturm" in Structure Manager and add column "bl_rev_release_status_list" and find the BOMLines with desired status name.

Re: Build a Query for searching parts with status in an assembly

Solution Partner Creator Solution Partner Creator
Solution Partner Creator
Hi xplm2005,

Thank you for your help. Your idea is a better one. But it would be complex, if i have for example in Structure Manager more than 1000 parts and i have to find some with Release status.

Any way thank you so much and let's find the solving together! Smiley Happy

Re: Build a Query for searching parts with status in an assembly

Siemens Phenom Siemens Phenom
Siemens Phenom

Hi,
It looks like you ran a database search then you cannot limit the result to your assembly. Load the structure in Structure Manager and run a Strucutre Manager Search. There you can limit the search on the assembly.

 

screenshot.png

 

xtof

Re: Build a Query for searching parts with status in an assembly

Phenom
Phenom

thanks @xtof this seems to be a good option. But it requires a license ?!? 

 

I got following error when I tried to perform search:

 

Error in Searching Object: No Flexlm license if available for Teamcenter optional module 'context_mgt_access'.

Re: Build a Query for searching parts with status in an assembly

Siemens Phenom Siemens Phenom
Siemens Phenom

ok, cacheless search needs an additional license but standard search should be available. For cacheless search you don't have to load the strcutture for standard search you have to load and expand the structure.

HTH,

xtof


ss.png

Re: Build a Query for searching parts with status in an assembly

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hello guys,

Thank you for your help. It seem like good to find some parts in SM.
@xtof Addtional i have more question for you. If i dont have problem with license. Which relation type and form type should be entered in the SM search panel?

 

About relation is actualy still not clear for me.

Thank you for your answer!

 

nithi

Re: Build a Query for searching parts with status in an assembly

Phenom
Phenom

thanks @xtof again! this looks good and worked for me.

Re: Build a Query for searching parts with status in an assembly

Siemens Phenom Siemens Phenom
Siemens Phenom

Hi nithi,

In cacheless search you can select from the same list than in Search view e.g. in My Teamcenter. If you want to search for properties on forms you should use Query Builder to configure your own query. 

xtof