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
|