Query Builder on EPMDoc

[Marco_Tosin]

Hi all,

another question about Query Builder.

I'm working on a report about EPMDoc where my goal is finding docs that have been modified in a given period.

I have selected EPMDoc and LyfeCycle History.

The difficult thing regards the state: what I would like is to find all the docs that, starting from Release state in any versions and in any date,have been modified by creating a new revision, for example, in the last two months.

Any idea?

TIA

[DarrenStorey]

Marco

You I don't think you even need to look at state for this.Simple filter to give latest of each revision, then exlcude revision 1 docs. This will give you all new revisions (post initial release).You can filter further by excluding those created before a cetain date.

I believe the attached QML gives you want you need. It excludes revision "1", if you have alphabetic revisions you will need to modify the filter slightly.

Regards

Darren

[Marco_Tosin]

Darren,

your report and suggestions drives me in the right direction.

Thanks a lot

Marco