Skip to main content
MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
March 19, 2013
Question

Query Builder on EPMDoc

  • March 19, 2013
  • 2 replies
  • 700 views

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


2 replies

D
DarrenStorey12-Amethyst
12-Amethyst
March 20, 2013

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

MarcoTosin
MarcoTosin21-Topaz IAuthor
21-Topaz I
March 20, 2013

Darren,


your report and suggestions drives me in the right direction.


Thanks a lot



Marco

Marco
Terms & ConditionsAccessibility statement