Changes for page Forthcoming
From version 58.1
edited by Andrea Omicini
on 16/06/2023 13:09
on 16/06/2023 13:09
Change comment:
There is no comment for this version
To version 59.1
edited by Andrea Omicini
on 16/06/2023 13:27
on 16/06/2023 13:27
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,14 +1,17 @@ 1 1 {{velocity}} 2 2 {{html wiki="true" clean="false"}} 3 3 #template('apice_events.vm') 4 +#template('apice_macros.vm') 5 +#isuserspace() 4 4 ## 5 -#if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 7 +#if( $isUserSpace ) 8 + #userspace() 6 6 ## overall forthcoming events 7 - #set( $query = ", BaseObject objEvent, DateProperty as propDate 8 - where doc.fullName = objEvent.name and objEvent.className = '${objectSpace}.${objectClass}' and objEvent.name <> '${objectPool}.${objectTemplate}' and propDate.id.id = objEvent.id and propDate.name = 'start_date' and propDate.value > current_date() order by propDate.value asc " ) 9 -#else 10 10 #set( $query = ", BaseObject as objEvent, BaseObject as objRole, LargeStringProperty as propWho, DateProperty as propDate 11 11 where objEvent.name = doc.fullName and objEvent.className = '${objectSpace}.${objectClass}' and objEvent.name <> '${objectPool}.${objectTemplate}' and propDate.id.id = objEvent.id and propDate.name = 'start_date' and propDate.value > current_date() and objRole.name = doc.fullName and objRole.className = '${objectSpace}.Roles.${objectClass}' and propWho.id.id = objRole.id and propWho.name = 'who' and propWho.value like '%$userName%' order by propDate.value asc " ) 12 +#else 13 + #set( $query = ", BaseObject objEvent, DateProperty as propDate 14 + where doc.fullName = objEvent.name and objEvent.className = '${objectSpace}.${objectClass}' and objEvent.name <> '${objectPool}.${objectTemplate}' and propDate.id.id = objEvent.id and propDate.name = 'start_date' and propDate.value > current_date() order by propDate.value asc " ) 12 12 #end 13 13 ## execute query 14 14 #set( $eventsFound = $xwiki.searchDocuments($query) )