cancel
Showing results for 
Search instead for 
Did you mean: 

Create query to find latest status.

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hi,

 

I have these released status list for two different Itemerevisions:

  • PROTO, BLOCK, RELEASED, OBSOLETE
  • PROTO, RELEASED

I would like to create a query where I find only the Itemrevision with RELEASED as lastest revision date. When I create a query (ItemRevsion as search class) with "release_status_list.name" as search criteria. I get the both Iterevision if I search for status "RELEASED".

 

How can I only find the PROTO, RELEASED Itemrevision?

 

Marcel

1 REPLY

Re: Create query to find latest status.

Siemens Phenom Siemens Phenom
Siemens Phenom

Hi,

I think it is not possible to do with OOTB query. 

Something like Status=RELEASED AND Status!=OBSOLETE does not work.

Regards,

xtof