Changes for page Deadlines

From version 70.1
edited by Andrea Omicini
on 27/04/2023 08:35
Change comment: There is no comment for this version
To version 71.1
edited by Andrea Omicini
on 04/05/2023 23:51
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -8,10 +8,10 @@
8 8   #set( $userString = "%$userName%" )
9 9  #end
10 10  ## overall incoming deadlines
11 -#set( $query = "select doc.fullName from XWikiDocument doc, BaseObject objEvent, DateProperty as propDate #if( $oneUser), BaseObject as objRole, LargeStringProperty as propWho #end
11 +#set( $query = ", BaseObject objEvent, DateProperty as propDate #if( $oneUser), BaseObject as objRole, LargeStringProperty as propWho #end
12 12   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 ")
13 13  ## execute query
14 -#set( $eventsFound = $xwiki.search($query) )
14 +#set( $eventsFound = $xwiki.searchDocuments($query) )
15 15  ##
16 16  #if( $eventsFound.size() > 0 )
17 17  >{{stringEngIta eng="Incoming Deadlines" ita="Prossime scadenze"/}}