Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Count

Count is the simplest of aggregate functions, and will just return the count of matching entities.

Examples

Count all records in Enterprise Tester

Code Block
languagenone
Count

Count all records in a project

Code Block
languagenone
Count WHERE Project = 'Project X'

Count all incidents in a project with a status of "Open"

Code Block
languagenone
COUNT WHERE Project = 'Project X' AND EntityType = Incident AND Status = Open

Count all incidents, grouped by their status

Code Block
languagenone
GROUP BY Status { COUNT } WHERE Project = 'Project X' AND EntityType = Incident