All topics
Filter operators
Which filter operators each field type offers.
Which operators a filter rule offers depends on the type of the thing being tested. has a value and is empty take no value and are available on every type — they are how you find the records somebody never finished filling in.
| Field type | Operators |
|---|---|
| Text | contains · does not contain · is · has a value · is empty |
| Choice, Category, Status | is · is not · has a value · is empty |
| Number | is · is more than · is less than · has a value · is empty |
| Date | is · is after · is before · has a value · is empty |
Asset ID, Address and Description are text; Last updated is a date. Your own asset fields use whichever type you gave them in Settings.
Something not covered here?
Email [email protected] — we usually reply the same day. If you are not set up yet, we will put your municipality on the map in about twenty minutes.