Aggregation
Aggregation queries allow you to take a normal TQL query and calculate summary information over the set of results. It is a powerful feature that provides the functionality within Enterprise Tester to support complex reports and graphs, and we put that power into your hands.
...
This query will return a single value, the count of all entities within EnterpriseTester that you have permission to view:
To apply the above aggregation to a query you use the "WHERE" keyword:
...
Which would return results like this:
Aliases
Names assigned to values returned in a query will by default be computed based on the field and function being used - you can correct this by applying an Alias using the "AS" keyword.
Code Block | ||
---|---|---|
| ||
Min(CreatedAt) AS "First requirement added at", Max(CreatedAt) AS "Last requirement added at" WHERE EntityType = Requirement And Project = 'Project X' |
Grouping
To group by a field such as priority or status you can use the Group By aggregate function.
...