Cancel
Showing results for 
Search instead for 
Did you mean: 

Query Builder: Find Item Revision without release_status

Creator
Creator

Hi, 

In Query Builder I can find some item revision with release_status like this: release_status_list.name = MyStatus.

 

How can I find item revision not contains MyStatus but contains other statuses?

 

For example I have item revision with status Approved. If I use release_status_list.name != MyStatus, I found this revision, because Approved != MyStatus. 

9 REPLIES

Re: Query Builder: Find Item Revision without release_status

Valued Contributor
Valued Contributor

Hi

 

You can do this with a report. 

Against the required other status's 

please see attached screen grabs. 

 

You can select the required item type and the status both from drop downs

 

 

Re: Query Builder: Find Item Revision without release_status

Creator
Creator

1) I need find element doesn't contains release_status. This report find elements with resease_status.

2) In next I want to you Query in Workflow Condition element to automation my workflow. How can I include report or plmxml export/import to Workflow?

Re: Query Builder: Find Item Revision without release_status

Valued Contributor
Valued Contributor

If you run the report with out selecting a status it will give you everything that isnt statused. You may need to change your preferance Crf_Report_objects_limit if you have many unstatused parts.

 

 

Re: Query Builder: Find Item Revision without release_status

Creator
Creator
Element that I search can has any other statuses but doesn't has MyStatus. How can I find all similar elements?

E.g. element A has status Approved, element B has status MyStatus, element C has statuses Approve and MyStatus, element D hasn't statuses. In result I must find only A and D elements.

Re: Query Builder: Find Item Revision without release_status

Phenom
Phenom

Good afternoon, if you use it in Workflow, you can try two consecutive checks:

1) release_status_list.name = Approved
2) release_status_list IS_NULL

Re: Query Builder: Find Item Revision without release_status

Creator
Creator

Okay, describe the situation.

 

In Teamcenter I have some Items with Revisions. Some Revisions have status Approved. Some Revisions have another status, e.g. MyStatus.

I want to find Items, who doesn't contains status Approved.

 

See screenshot.

Screenshot3.png

 

Element 025133 has status Approved. Element 025135 has status MyStatus. Element TestDet102 has both status: Approved and MyStatus.

 

In result I must get only element 025135 and ignore elements TestDet102 and 025133. 

 

I wrote query: 

Screnshot4.png

 

But this returns elements 025135 and TestDet102 too.

 

 

 

Re: Query Builder: Find Item Revision without release_status

Pioneer
Pioneer

@dkotlyar

 

Your status object is on Item Revision, But in search class you have selected Item.

Change your search class to item revision and give a try. It may work.

 

query.JPG

 

Thanks.

Re: Query Builder: Find Item Revision without release_status

Creator
Creator

I need to find Item with analize ItemRivisions

Re: Query Builder: Find Item Revision without release_status

Creator
Creator
And if I set search class ItemRevision. It doesn't solve my issue. In result must be only ItemRevision without Approved.