Cancel
Showing results for 
Search instead for 
Did you mean: 

Query builder - Objects with only one particular status

Pioneer
Pioneer

Is it possible or any trick to design a query in query builder to find all object which have 'released' status n no other status

 

Objects might have multiple statuses, I'm interested in getting objects which have only one particular status

9 REPLIES

Re: Query builder - Objects with only one particular status

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

Add additional clauses like "AND release_status_list != other_release_status" where "other_release_status" is the name of each release status that should not appear?

Arden Bedell | Teamcenter Wonk | Applied CAx, LLC

Re: Query builder - Objects with only one particular status

Pioneer
Pioneer

Hi Arden,

 

Thanks for your response; I tried this already but it didn't work.

 

 

Re: Query builder - Objects with only one particular status

Valued Contributor
Valued Contributor

Its not possible to achieve that using query builder since the release status is an array of status tags. You need to write an user exit query if necessary.

Re: Query builder - Objects with only one particular status

Pioneer
Pioneer

Thanks Santosh, for your response.

I did try couple of things.. but could not achieve it..
any idea.. if 'revision rule' field in query builder may be used somehow to achieve it..
I have not yet explored it.

Re: Query builder - Objects with only one particular status

Creator
Creator

hello

 

if you have defined a Released status in BMIDE you can use this property (release_status_list.name) in the query

 

Saludos

Re: Query builder - Objects with only one particular status

Valued Contributor
Valued Contributor

Use General Search --> Select Type (object Type) find your object

Use Release Status ---> Select Type

Clear your user name.

 

Hope this helps

Paul

Re: Query builder - Objects with only one particular status

Pioneer
Pioneer

Hi Paul and jlac,

 

Thanks for your time and response.

However, I am intersted in objects which have ONLY one status and no other statuses.

 

 Your recommended solution will give results, with multiple statuses also.

 

I have checked on different forums and GTAC also, there is no OOTB way to filter it out (through Query builder)

 

Regards

 

Re: Query builder - Objects with only one particular status

Valued Contributor
Valued Contributor

The status type when selected will give you one particular status. 

Re: Query builder - Objects with only one particular status

Solution Partner Honored Contributor Solution Partner Honored Contributor
Solution Partner Honored Contributor

@steelcar, what @Gunjan is telling you is that if an IR has multiple statuses applied (legal in his system) then the query returns ANY that have a matching status and he wants ONLY that have a matching status (without multiple statuses).

 

He wants something like:

Search Type = WorkspaceObject

Search Criteria: object_type = ItemRevision AND release_status_list.count = 1 AND release_status_list.name = "Production"

 

Unfortunately, release_status_list.count doesn't exist and makes this task impossible without code.


Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4