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 | ||
---|---|---|
| ||
Count |
Count all records in a project
Code Block | ||
---|---|---|
| ||
Count WHERE Project = 'Project X' |
Count all incidents in a project with a status of "Open"
Code Block | ||
---|---|---|
| ||
COUNT WHERE Project = 'Project X' AND EntityType = Incident AND Status = Open |
Count all incidents, grouped by their status
Code Block | ||
---|---|---|
| ||
GROUP BY Status { COUNT } WHERE Project = 'Project X' AND EntityType = Incident |