QPR Reporting Expression

From Mea Wiki
Revision as of 15:54, 16 November 2017 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

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')
Retrieved from "https://wiki.onqpr.com/mea/index.php?title=QPR_Reporting_Expression&oldid=6745"