Changes for page Per Status

From version 74.1
edited by Andrea Omicini
on 02/01/2023 23:59
Change comment: There is no comment for this version
To version 76.1
edited by Andrea Omicini
on 03/01/2023 00:02
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -81,19 +81,23 @@
81 81   #set( $statusList = [$statusPar] )
82 82   #end
83 83  #end
84 +$statusList
84 84  ##
85 85  ## query to structures
86 86  #set( $pubMap = {} )
87 87  #set( $pubNo = 0 )
88 88  #foreach( $status in $statusList )
90 +$status
89 89   #set( $from = ", BaseObject as obj, LargeStringProperty as prop0, LargeStringProperty as prop1, StringProperty as prop2" )
90 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 93   #set( $pubStatusNo = $pubFound.size() )
96 +$pubFound
97 +$pubFound.size()
94 94   #if( $pubStatusNo > 0 )
95 95   #set( $pubMap[$status] = $pubFound )
96 - #set( $pubNo = $pubNo + $pubYearNo )
100 + #set( $pubNo = $pubNo + $pubStatusNo )
97 97   #end
98 98  #end
99 99  $pubMap