reporting average values
In one application we use the eval-data macro to calculate average
values which are reported on the parent page. Within the report we use
the average values as parameters for a user macro. Recently we updated
to Confluence 2.10.3 and the current versions of Scaffolding and
Reporting. It all seemed to work well until we added a new child page
to the reporting page. Instead of the report we got an error message:
"Error formatting macro: report-table: net.customware.confluence.
reporting.supplier.SupplierValueException:
Error while comparing 'data:averageQuality':
Unsupported class type -
org.randombits.confluence.metadata.reference.ExpressionReference
cannot be cast to java.lang.Number"
After several hours of investigations we found, that the current
Scaffolding plugin does not store the result of the calculation but
the expression to calculate the average. This seems to be incompatible
with report-info and keychain injection. Using get-data macro it is
possible to retrieve the average value as expected. But to pass the
values as parameters to a user macro we need keychain injection.
How to work around the problem?
values which are reported on the parent page. Within the report we use
the average values as parameters for a user macro. Recently we updated
to Confluence 2.10.3 and the current versions of Scaffolding and
Reporting. It all seemed to work well until we added a new child page
to the reporting page. Instead of the report we got an error message:
"Error formatting macro: report-table: net.customware.confluence.
reporting.supplier.SupplierValueException:
Error while comparing 'data:averageQuality':
Unsupported class type -
org.randombits.confluence.metadata.reference.ExpressionReference
cannot be cast to java.lang.Number"
After several hours of investigations we found, that the current
Scaffolding plugin does not store the result of the calculation but
the expression to calculate the average. This seems to be incompatible
with report-info and keychain injection. Using get-data macro it is
possible to retrieve the average value as expected. But to pass the
values as parameters to a user macro we need keychain injection.
How to work around the problem?
1
person has this problem
I have this problem, too!
Tell me when someone solves it.
The more people who report this problem, the more it gets noticed.
The more people who report this problem, the more it gets noticed.
-
Inappropriate?The error message should be more useful, but you need to add '> reference:value' after your 'data:averageQuality'. Eg:
{number-sort:data:averageQuality > reference:value|order=descending}
This will make the ExpressionReference run its calculation and let you compare on the value.
Loading Profile...



EMPLOYEE