query for files that went through a transition and get a rev-up

Hi There,

I'm a part-time ePDM admin and my VAR could not help me with this. My colleague found the a few of his files (related/referenced files) have their revision up by 1 while going through a transition. Normally, that transition is not supposed to up the revision.

I am looking for a query (could be a template of a query) for files that have gone through the transition 'EC Submit for Review' and have revision up by 1 (or A to B, etc.).

Thanks in advance,

Aaron.

SolidworksSolidworks Pdm enterprise Pdm