Difference between revisions of "QPR Reporting Expression"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
</pre> | </pre> | ||
| + | The following query will return 20 process element instances which have the greatest width in the flowchart. | ||
| + | <pre> | ||
| + | instances=From('[PG].models.subobjects.instances', '', '', 'name,id', '') | ||
| + | calculateColumns=AddColumn(AddColumn([instances], 'elementInstanceId', 'InstanceIdFromFullId([id])'), 'elementWidth', 'ConvertToDouble(ItemAt(SubAttributesAsArray([id], \'graphicalproperties\', \'width\', \'[instanceid]=[elementInstanceId]\'), 0))') | ||
| + | sortedData=SortBy([calculateColumns], 'elementWidth desc') | ||
| + | getMax20=Where(AddColumn([sortedData], 'rowordernumber', '[rowordernumber]'), '[rowordernumber] < 20') | ||
| + | </pre> | ||
[[Category: QPR UI]] | [[Category: QPR UI]] | ||
Revision as of 16:19, 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')
The following query will return 20 process element instances which have the greatest width in the flowchart.
instances=From('[PG].models.subobjects.instances', '', '', 'name,id', '')
calculateColumns=AddColumn(AddColumn([instances], 'elementInstanceId', 'InstanceIdFromFullId([id])'), 'elementWidth', 'ConvertToDouble(ItemAt(SubAttributesAsArray([id], \'graphicalproperties\', \'width\', \'[instanceid]=[elementInstanceId]\'), 0))')
sortedData=SortBy([calculateColumns], 'elementWidth desc')
getMax20=Where(AddColumn([sortedData], 'rowordernumber', '[rowordernumber]'), '[rowordernumber] < 20')