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.
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?
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.
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
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.
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:
But this returns elements 025135 and TestDet102 too.