From version < 3.1 >
edited by Vincent Massol
on 2014/07/21 18:38
To version < 4.1 >
edited by Vincent Massol
on 2014/07/21 18:40
< >
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -2,10 +2,14 @@
2 2  
3 3  Use ##confirm=1## to execute.
4 4  
5 +Pass ##start## and ##end## parameters to specify the dates.
6 +
7 +For example: ##start=2013-06-30&end=2014-06-30##.
8 +
5 5  {{groovy}}
6 6  if (request.confirm == '1') {
7 7   def total = 0
8 - services.query.xwql("from doc.object(ExtensionCode.ExtensionClass) as extension where doc.space = 'Extension' and doc.creationDate >= '2013-06-30' and doc.creationDate < '2014-06-30'").execute().each() {
12 + services.query.xwql("from doc.object(ExtensionCode.ExtensionClass) as extension where doc.space = 'Extension' and doc.creationDate >= :start and doc.creationDate < :end").bindValue('start', request.start).bindValue('end', request.end).execute().each() {
9 9   println "* ${it}"
10 10   total++
11 11   }

Shows how many extensions have been created between 2 dates.

Use confirm=1 to execute.

Pass start and end parameters to specify the dates.

For example: start=2013-06-30&end=2014-06-30.

Get Connected