Difference between revisions of "QPR Reporting Expression"
Jump to navigation
Jump to search
(307035) |
(307035) |
||
| Line 1: | Line 1: | ||
When querying the Generic Web Service, use the [[Reporting_Add-on#QPR_Web_Services_Extensions_Expression_Language|QPR Reporting Add-on Expression Engine Language]]. | When querying the Generic Web Service, use the [[Reporting_Add-on#QPR_Web_Services_Extensions_Expression_Language|QPR Reporting Add-on Expression Engine Language]]. | ||
| + | |||
| + | == Examples == | ||
| + | The following query will count how many scorecards there are in each QPR Metrics model: | ||
| + | |||
| + | <pre> | ||
| + | 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') | ||
| + | </pre> | ||
[[Category: QPR UI]] | [[Category: QPR UI]] | ||
Revision as of 11:42, 16 November 2017
When querying the Generic Web Service, use the QPR Reporting Add-on Expression Engine Language.
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')