Power Search

The search field accepts full Lucene query syntax — the text-based equivalent of the filter builder. Both express the same conditions; power search lets you type them directly rather than building them through the UI. Click the i icon in the search field to open a built-in cheat sheet at any time.

Basic Terms

A bare word matches any record where that term appears (case-insensitive):

visa

Wrap in single or double quotes for a case-sensitive match:

'Visa'
"Visa"

Field-Scoped Queries

Target a specific field with field:value. Field names with spaces must be quoted:

name:acme
'full name':acme
name.first:john

Comparison Operators

Use :=, :>, :<, :>=, :<= for numeric and date comparisons:

amount:=100
amount:>100
amount:>=100
amount:<100
amount:<=100
createdAt:=2024-01-01T00:00:00Z
createdAt:>2024-01-01T00:00:00Z

Ranges

Square brackets are inclusive, curly braces are exclusive:

amount:[100 TO 200]
amount:{100 TO 200}
createdAt:[2024-01-01T00:00:00Z TO 2024-12-31T23:59:59Z]

Wildcards

• * matches any sequence of characters
• ? matches exactly one character

name:acme*
reference:TXN?001
name:foo*bar

Boolean and Null Values

active:true
active:false
active:null

Boolean Operators

Combine terms with AND, OR, and NOT (must be uppercase). A space between terms is an implicit AND:

status:active AND currency:EUR
status:failed OR status:declined
NOT status:archived
name:foo height:=100

Negation Shorthand

Prefix a term or field query with - as a shorthand for NOT:

-foo
-status:archived
name:foo AND NOT (status:failed OR status:declined)

Grouping

Use parentheses to control precedence:

(status:active OR status:pending) AND currency:USD
name:foo AND (bio:bar OR bio:baz)

Examples

Goal	Query
Active EUR records	status:active AND currency:EUR
Transactions over $1,000	amount:>1000
Transactions between $100 and $500	amount:[100 TO 500]
Tenant names starting with "acme"	name:acme*
Failed or declined in January 2024	(status:failed OR status:declined) AND createdAt:[2024-01-01T00:00:00Z TO 2024-01-31T23:59:59Z]
Exclude archived	-status:archived
Case-sensitive exact match	'Acme Corp'