Modifiche per il documento Scadenze

Dalla versione 59.2
modificato da Andrea Omicini
il 01/04/2023 20:00
Cambia il commento: Nessun commento per questa versione
Alla versione 59.3
modificato da Andrea Omicini
il 01/04/2023 20:01
Cambia il commento: Nessun commento per questa versione

Summary

Details

Page properties
Content
... ... @@ -6,8 +6,8 @@
6 6   #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop
7 7   where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' and prop.id.id = obj.id and prop.name = 'paper_submission' and ( ( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) order by date(prop.value) asc ")
8 8  #else
9 - #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, BaseObject as obj1, DateProperty as prop
10 - where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' and prop.id.id = obj.id and prop.name = 'paper_submission' and ( ( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) and obj1.name = doc.fullName and obj1.className = '${objectSpace}.Roles.${objectClass}' and prop1.id.id = obj1.id and prop1.name = 'who' and prop1.value like '%$userName%' order by date(prop2.value) asc " )
9 + #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop
10 + where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' and prop.id.id = obj.id and prop.name = 'paper_submission' and (( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) and obj1.name = doc.fullName and obj1.className = '${objectSpace}.Roles.${objectClass}' and prop1.id.id = obj1.id and prop1.name = 'who' and prop1.value like '%$userName%' order by date(prop2.value) asc " )
11 11  #end
12 12  ## execute query
13 13  #set( $eventsFound = $xwiki.search($query) )