Changes for page Supervisors
From version 92.1
edited by Andrea Omicini
on 29/01/2023 21:29
on 29/01/2023 21:29
Change comment:
There is no comment for this version
To version 91.1
edited by Andrea Omicini
on 29/01/2023 21:23
on 29/01/2023 21:23
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
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' #if( $oneUser )and prop0.value like '$userString'#end 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() )