Difference between revisions of "QPR Reporting Expression"
Jump to navigation
Jump to search
(307035) |
|||
| Line 1: | Line 1: | ||
| − | When querying the Generic Web Service, use the [[Reporting_Add-on# | + | When querying the Generic Web Service, use the [[Reporting_Add-on#QPR_Reporting_Expression_Language|QPR Reporting Expressions]]. |
== Examples == | == Examples == | ||
Revision as of 15:54, 16 November 2017
When querying the Generic Web Service, use the QPR Reporting Expressions.
Examples
The following query will count how many scorecards there are in each QPR Metrics model:
scorecards=From('[SC].models.scorecard', '', '', 'model.name(as="modelname"),id')
countSums=SortBy(GroupBy([scorecards], Array('modelname'), Array('numberOfScorecards'), Array('ArraySize([id])')), 'numberOfScorecards DESC')
sortedResult=SortBy([countSums], 'numberOfScorecards DESC')