Changes for page Deadlines

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

Summary

Details

Page properties
Content
... ... @@ -7,7 +7,7 @@
7 7  ## user forthcoming events
8 8  ## incoming deadlines
9 9  #set( $query = ", BaseObject objEvent, DateProperty as propDate #if( $oneUser), BaseObject as objRole, LargeStringProperty as propWho #end
10 - where doc.fullName = objEvent.name and objEvent.className = '${objectSpace}.Class' and objEvent.name <> '${objectPool}.Template' and propDate.id.id = objEvent.id and propDate.name = 'paper_submission' and date(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 '$userString' #end order by date(propDate.value) asc ")
10 + where doc.fullName = objEvent.name and objEvent.className = '${mainSpace}.Class' and objEvent.name <> '${objectPool}.Template' and propDate.id.id = objEvent.id and propDate.name = 'paper_submission' and date(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 '$userString' #end order by date(propDate.value) asc ")
11 11  ## execute query
12 12  #set( $itemFound = $xwiki.searchDocuments($query) )
13 13  ##