Difference between revisions of "QPR Reporting Expression"
Jump to navigation
Jump to search
| Line 27: | Line 27: | ||
</pre> | </pre> | ||
| − | The following query | + | The following query returns a random number between 0 and 100 in a dataset which contains one row and one column which name is "data": |
<pre> | <pre> | ||
randomNumber=AddDatasetRow(CreateDataset(Array('data')), Floor(Random() * 101)) | randomNumber=AddDatasetRow(CreateDataset(Array('data')), Floor(Random() * 101)) | ||
</pre> | </pre> | ||
[[Category: QPR UI]] | [[Category: QPR UI]] | ||
Revision as of 14:54, 19 November 2017
When querying the Generic Web Service, use the QPR Reporting Expressions.
Examples
The following query counts 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. Note that running the following query may take time, if there are lot of process models and elements inside them.
instances=From('[PG].models.subobjects.instances', '', '', 'name,id', '')
getWidth=AddColumn(AddColumn([instances], 'elementInstanceId', 'InstanceIdFromFullId([id])'), 'elementWidth', 'ConvertToDouble(ItemAt(SubAttributesAsArray([id], \'graphicalproperties\', \'width\', \'[instanceid]=[elementInstanceId]\'), 0))')
sortedData=SortBy([getWidth], 'elementWidth desc')
getMax20=Where(AddColumn([sortedData], 'rowordernumber', '[rowordernumber]'), '[rowordernumber] < 20')
The following query is an example of joining two datasets. It returns a line for each user-group assignment.
users=From('[UM].users', '', '', 'name(as="username"),fullname,email,id(as="userid"),ingroups', '')
groups=From('[UM].groups', '', '', 'name(as="groupname"),id(as="groupid")', '')
joined=RemoveColumns(LeftJoin([users], [groups], 'Contains([ingroups], [groupid])'), Array('ingroups'))
The following query returns a random number between 0 and 100 in a dataset which contains one row and one column which name is "data":
randomNumber=AddDatasetRow(CreateDataset(Array('data')), Floor(Random() * 101))