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
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?
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.
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.
Use General Search --> Select Type (object Type) find your object
Use Release Status ---> Select Type
Clear your user name.
Hope this helps
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)
@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.
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4