Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Image Modified

To apply the above aggregation to a query you use the "WHERE" keyword:

...

Which would return results like this:

Image Added

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.Image Removed

Code Block
languagenone
Min(CreatedAt) AS "First requirement added at", Max(CreatedAt) AS "Last requirement added at" 
WHERE EntityType = Requirement And Project = 'Project X'

Image Modified

Grouping

To group by a field such as priority or status you can use the Group By aggregate function.

...