Changes for page Deadlines
From version 86.1
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
To version 85.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
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -5,7 +5,7 @@ 5 5 ## user forthcoming events 6 6 ## incoming deadlines 7 7 #set( $query = ", BaseObject objEvent, DateProperty as propDate #if( $oneUser), BaseObject as objRole, LargeStringProperty as propWho #end 8 - 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 ") 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 = 'paper_submission' and date(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 '$userString' #end order by date(propDate.value) asc ") 9 9 ## execute query 10 10 #set( $itemFound = $xwiki.searchDocuments($query) ) 11 11 ##