Question
How to use sub query in query manager
Hello All,
Business needs a report for all the released parts. If a later revision of the part is in specific lifecycle state (for example "Packaged") the earlier released parts should not be reported in the query builder report. If I specify the criteria as state = Released OR state = Packaged, both released and packaged parts are listed in the report. Is there a way to use sub select for filtering out the earlier "Released" part if the later one is in "Packaged" state.
Thanks in advance,
Saravanan
Business needs a report for all the released parts. If a later revision of the part is in specific lifecycle state (for example "Packaged") the earlier released parts should not be reported in the query builder report. If I specify the criteria as state = Released OR state = Packaged, both released and packaged parts are listed in the report. Is there a way to use sub select for filtering out the earlier "Released" part if the later one is in "Packaged" state.
Thanks in advance,
Saravanan