Changes for page Forthcoming

From version 65.1
edited by Andrea Omicini
on 03/07/2023 23:54
Change comment: There is no comment for this version
To version 66.1
edited by Andrea Omicini
on 06/07/2023 20:07
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -6,7 +6,7 @@
6 6  #template('apice_user_param.vm')
7 7  ## user forthcoming events
8 8  #set( $query = ", BaseObject as objEvent #if( $oneUser ), BaseObject as objRole, LargeStringProperty as propWho #end, DateProperty as propDate
9 - 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 " )
9 + where objEvent.name = doc.fullName and objEvent.className = '${mainSpace}.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 = '${mainSpace}.Roles.Class' and propWho.id.id = objRole.id and propWho.name = 'who' and propWho.value like '%$userName%' #end order by propDate.value asc " )
10 10  ## execute query
11 11  #set( $itemFound = $xwiki.searchDocuments($query) )
12 12  ##