query/count.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48


Count
back to query /// home
Count rows matching a filter. Like select but just gives you the number in data field.
Request
{
  "action": "count",
  "table": "items",
  "filter": {
    "column": "status",
    "op": "=",
    "value": "active"
  }
}


Fields


Field
Type
Required
Notes


action
string
yes
must be "count"


table
string
yes
target table


where
object
no
simple key value filter


filter
object
no
structured filter


joins
array
no
join other tables if needed


No limit or offset for count, it always counts everything that matches.
Response
{
  "success": true,
  "data": 42
}


data is just the count as a number.
Behaviors

should support joins so you can count rows with conditions on related tables
ownership scoping should apply: if you have rwo or rwg the count should only include rows you have access to
you need at least read permission on the table