Searching certain WTParts by State with WRS

[DanWolf]

Version: Windchill 12.0

Use Case: I'm using GetParts to search WTParts in Windchill using a filter like "startswith(Number, '12345')". I want to get the latest revision at the "Released" state if one exists, otherwise get the latest revision. Is there a way to construct a filter to return the latest "Released" revision but if there are none, just return the latest revision regardless of its state?

Description:

I can filter by State/Value eq 'XXX', but I feel like I need to have a conditional in there saying if that state is not found for any revisions, return the latest revision.

[anursingh]

Hi @DanWolf,

Thank you for your question. 

Your post appears well documented but has not yet received any response. I am replying to raise awareness. Hopefully, another community member will be able to help.

Also, feel free to add any additional information you think might be relevant. It sometimes helps to have screenshots to better understand what you are trying to do. 

Regards,

Anurag