Changes for page Forthcoming
From version 27.2
edited by Andrea Omicini
on 22/06/2022 18:20
on 22/06/2022 18:20
Change comment:
There is no comment for this version
To version 29.1
edited by Andrea Omicini
on 22/06/2022 18:23
on 22/06/2022 18:23
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -4,7 +4,7 @@ 4 4 #if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 5 5 ## overall forthcoming events 6 6 #set( $sql = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop 7 - where doc.fullName = obj.name and obj.className = ' Events.Class' and obj.name <> 'Events.Template' and prop.id.id = obj.id and prop.name = 'start_date' and ( ( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) order by date(prop.value) asc ")7 + where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> 'Events.Template' and prop.id.id = obj.id and prop.name = 'start_date' and ( ( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) order by date(prop.value) asc ") 8 8 #set( $eventFound = $xwiki.search($sql) ) 9 9 #foreach($event in $eventFound) 10 10 #set( $eventDoc = $xwiki.getDocument($event) )