AnsweredAssumed Answered

Find documents where system Rev doesn't match document Rev

Question asked by Jonathan Gamble on Oct 14, 2010
Latest reply on Jun 22, 2014 by Jason Clarke

We appear to have some drawings in which the custom revision property doesn't match the EPDM "System" revision (I think something went wrong during the original import).  The drawings have the custom revision variable mapped to the title block, so the drawing may be at rev 'B', but the history shows the latest released rev to be 'A'.  I am trying to conduct a search to find all these drawings.


Problem #1 is that it doesn't appear possible to compare two variables on a search card, so I can't do something like "Custom_Rev_Variable <> System_Rev"


So my next attempt was to modify the 'version data' tab on the Complete Search Card to reference the "Revision No." search variable (with the little magnifying glass next to it), then run the search with 'A' in this field (without the quotes), and set the variable tab to look for "Custom_Rev_Variable" text-not-equal-to 'A' (again without the quotes). I cleared the "search all versions" check box so it would only look in the latest version.   Worst case I would only have to run this 26 times to check all possible rev values.


The problem is that this doesn't work.  The search returns drawings with all different released revision levels, which suggests that the "Revision No." search variable doesn't just look at the latest released ("system") rev.


So my question is, does anyone have a good way to find documents in which the revision doesn't match the system rev???  All comments very gratefully received!!