Query Statistic
Query Statistic returns a set of statistics matching the specified criteria in either list or aggregate form.
Warning: This Node is replaced by Get Key-Values.
Properties
StartDate
Type: String Input
The earliest date for which statistics should be retrieved. The date is represented as a string formatted as yyyy/MM/dd. In addition to absolute dates, relative dates are also supported. For example, the expression0/0/-1 will search back one day.
EndDate
Type: String Input
The latest date for which statistics should be retrieved. The date is represented as a string formatted as yyyy/MM/dd. In addition to absolute dates, relative dates are also supported. For example, the expression0/0/-1 will search back one day.
MatchGroup
Type: String Input
The Group within which to search for statistics. This is the value of the Group property specified when creating statistics with the Statistic or Bulk Statistic Nodes.
MatchKey
Type: String Input
An optional value that can be used to locate a single statistic by it's Key. If left blank, all results will be returned for the date range.
MatchStatus
Type: List Input
Unknown - Only Unknown results will be returned
InProgress - Only InProgress results will be returned
Warning - Only Warning results will be returned
Error - Only Error results will be returned
Success - Only Success results will be returned
Any - All results will be returned
Note that the ID is returned in the Result, and must be mapped with the IDs above.
Method
Type: List Input
List - All the results will be returned
CountByValue - The results will be grouped by Value, and the number of results for that Value
CountByStatus - The results will be grouped by Status, and the number of results for that Status
Result
Type: Xml Output
The results will be returned in Xml format. The format depends on the Method used.
Remarks
- The ID of the Status fields will be returned in the result, and can be mapped with the IDs as indicated in the Match Status.
- DateTime is UTC
Examples
See Sample Workflow for examples.