Modifiche per il documento Per stato
Dalla versione 81.2
modificato da Andrea Omicini
il 03/01/2023 00:13
il 03/01/2023 00:13
Cambia il commento:
Nessun commento per questa versione
Alla versione 80.1
modificato da Andrea Omicini
il 03/01/2023 00:09
il 03/01/2023 00:09
Cambia il commento:
Nessun commento per questa versione
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -87,10 +87,9 @@ 87 87 #set( $pubNo = 0 ) 88 88 #foreach( $status in $statusList ) 89 89 #set( $from = ", BaseObject as obj, LargeStringProperty as prop0, LargeStringProperty as prop1, StringProperty as prop2" ) 90 - #set( $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 = 'author' and prop1.name = 'editor' and ( prop0.value like '$userString' or ( prop0.value = '' and prop1.value like '$userString' ) ) and prop2.name = 'status' and prop2.value = '$status'" ) 90 + #set( $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 = 'author' and prop1.name = 'editor' and ( prop0.value like '$userString' or ( prop0.value = '' and prop1.value like '$userString' ) ) and prop2.name = 'status' and prop2.value = '$status'" ) 91 91 #set( $sql = $from + " where " + $where ) 92 92 #set( $pubFound = $xwiki.searchDocuments($sql) ) 93 - #set( $pubStatusNo = $pubFound.size() ) 94 94 #if( $pubStatusNo > 0 ) 95 95 #set( $pubMap[$status] = $pubFound ) 96 96 #set( $pubNo = $pubNo + $pubStatusNo )