Advanced search for latest file attachments
I have the following situation and need the help of the community.\
Is it possible to contruct a search that only shows the filename of the latest rev for the part? My search results are showing the file name for the older revisons of the part.
My search criteria is as follows:
Items | Part | Object Search
Lifecycle Phase| In | Development, Production, Prototype AND
Type| In | Frame AND
Filename | Is Not Null
The problem is only when I include the filename attribute to be shown in the results. AND the older revison of an item has a file attached with a different filename. If I leave the filename out of the attributes to be shown the results are OK. Problem is we want to see the filename. Is there a method to do a search where $CURRENTREV in $LATEST so it does not surface the olders revisons that have different filenames.