Changes for page Supervisors

From version 93.1
edited by Andrea Omicini
on 29/01/2023 21:42
Change comment: There is no comment for this version
To version 95.1
edited by Andrea Omicini
on 29/01/2023 21:46
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -13,8 +13,8 @@
13 13  ## subtitle
14 14  >{{stringEngIta eng="$objectEngPlural" ita= "$objectItaPlural"/}}#if( $oneUser ) / $userFirstName $userLastName#{end}
15 15  ## set query
16 - #set( $query = ", BaseObject as obj, StringProperty as prop1, DateProperty as prop2
17 - where obj.name = doc.fullName and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectSpace}.${objectTemplate}' and prop1.id.id = obj.id and prop2.id.id = obj.id and prop1.name = 'status' and lower(prop1.value) = 'completed' and prop2.name = 'end' order by prop2.value desc" )
16 + #set( $query = ", BaseObject as obj, LargeStringProperty as prop0, StringProperty as prop1, DateProperty as prop2
17 + where obj.name = doc.fullName and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectSpace}.${objectTemplate}' and prop0.id.id = obj.id and prop1.id.id = obj.id and prop2.id.id = obj.id and prop0.name = 'supervisors' and prop0.value <> '' and prop1.name = 'status' and lower(prop1.value) = 'completed' and prop2.name = 'end' order by prop2.value desc" )
18 18  ## execute query
19 19   #set( $itemFound = $xwiki.searchDocuments($query) )
20 20   #set( $itemFoundNo = $itemFound.size() )
... ... @@ -24,7 +24,6 @@
24 24   #foreach( $item in $itemFound )
25 25  ## set $doc & $obj
26 26   #set( $itemDoc = $xwiki.getDocument($item) )
27 - #set( $itemObj = $itemDoc.getObject("${objectSpace}.${objectClass}") )
28 28   #set( $nameList = $itemDoc.getValue("supervisors").split(",") )
29 29  ## set user-item map
30 30   #foreach( $name in $nameList )