Modifiche per il documento Per stato

Dalla versione 68.1
modificato da Andrea Omicini
il 31/12/2022 02:23
Cambia il commento: Nessun commento per questa versione
Alla versione 69.1
modificato da Andrea Omicini
il 31/12/2022 02:24
Cambia il commento: Nessun commento per questa versione

Summary

Details

Page properties
Content
... ... @@ -98,7 +98,7 @@
98 98  ##
99 99  #foreach( $status in $statusList )
100 100   #set( $from = ", BaseObject as obj, LargeStringProperty as prop0, LargeStringProperty as prop1, StringProperty as prop2" )
101 - #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'" )
101 + #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'" )
102 102   #set( $sql = $from + " where " + $where )
103 103   #set( $pubFound = $xwiki.searchDocuments($sql) )
104 104   #set( $pubStatusNo = $pubFound.size() )