Modifiche per il documento Relatori
Dalla versione 87.1
modificato da Andrea Omicini
il 29/01/2023 19:57
il 29/01/2023 19:57
Cambia il commento:
Nessun commento per questa versione
Alla versione 88.1
modificato da Andrea Omicini
il 29/01/2023 20:04
il 29/01/2023 20:04
Cambia il commento:
Nessun commento per questa versione
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -128,9 +128,8 @@ 128 128 #### YES TAG PARAMETER 129 129 #else 130 130 ## set query 131 - #set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, StringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4, DateProperty as prop5" ) 132 - #set ( $where = "obj0.className = 'XWiki.TagClass' and obj0.name = doc.fullName and obj0.id = prop0.id.id and prop0.id.name = 'tags' and lower(item) = lower('$request.tag') and obj1.name = doc.fullName and obj1.className = '${objectSpace}.${objectClass}' and obj1.name <> '${objectSpace}.${objectTemplate}' and prop1.id.id = obj1.id and prop2.id.id = obj1.id and prop3.id.id = obj1.id and prop4.id.id = obj1.id and prop5.id.id = obj1.id and prop1.name = 'status' and prop2.name = 'supervisors' and prop3.name = 'cosupervisors' and prop4.name = 'contacts' and prop5.name = 'end' and lower(prop1.value) = 'completed' #if( $oneUser )and ( prop2.value like '$userString' or prop3.value like '$userString' or prop4.value like '$userString' )#end order by prop5.value desc" ) 133 - #set( $query = $from + " where " + $where ) 131 + #set( $query = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, StringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4, DateProperty as prop5 132 + where obj0.className = 'XWiki.TagClass' and obj0.name = doc.fullName and obj0.id = prop0.id.id and prop0.id.name = 'tags' and lower(item) = lower('$request.tag') and obj1.name = doc.fullName and obj1.className = '${objectSpace}.${objectClass}' and obj1.name <> '${objectSpace}.${objectTemplate}' and prop1.id.id = obj1.id and prop2.id.id = obj1.id and prop3.id.id = obj1.id and prop4.id.id = obj1.id and prop5.id.id = obj1.id and prop1.name = 'status' and prop2.name = 'supervisors' and prop3.name = 'cosupervisors' and prop4.name = 'contacts' and prop5.name = 'end' and lower(prop1.value) = 'completed' #if( $oneUser )and ( prop2.value like '$userString' or prop3.value like '$userString' or prop4.value like '$userString' )#end order by prop5.value desc" ) 134 134 #set( $itemFound = $xwiki.searchDocuments($query) ) 135 135 #set( $itemFoundNo = $itemFound.size() ) 136 136 ## subtitle