Changes for page Forthcoming
From version 63.1
edited by Andrea Omicini
on 25/06/2023 10:47
on 25/06/2023 10:47
Change comment:
There is no comment for this version
To version 63.2
edited by Andrea Omicini
on 02/07/2023 19:55
on 02/07/2023 19:55
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 #template('apice_user_param.vm') 5 5 ## user forthcoming events 6 6 #set( $query = ", BaseObject as objEvent #if( $oneUser ), BaseObject as objRole, LargeStringProperty as propWho #end, DateProperty as propDate 7 - 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() #if( $oneUser ) 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%' #end order by propDate.value asc " )7 + where objEvent.name = doc.fullName and objEvent.className = '${objectSpace}.Class' and objEvent.name <> '${objectPool}.Template' and propDate.id.id = objEvent.id and propDate.name = 'start_date' and propDate.value > current_date() #if( $oneUser ) and objRole.name = doc.fullName and objRole.className = '${objectSpace}.Roles.Class' and propWho.id.id = objRole.id and propWho.name = 'who' and propWho.value like '%$userName%' #end order by propDate.value asc " ) 8 8 ## execute query 9 9 #set( $itemFound = $xwiki.searchDocuments($query) ) 10 10 ##