Search
Query syntax
Section titled “Query syntax”Search all fields
Section titled “Search all fields”Entering a plain value with no field prefix searches every text column:
johnSearch a specific field
Section titled “Search a specific field”Use field:value to target a column:
name:johnSearch inside JSON fields
Section titled “Search inside JSON fields”The pii and extra columns store JSON. Use dot notation to reach into them:
pii.email:@gmail.compii.phone:5551234extra.lat:40.7Exact match
Section titled “Exact match”Wrap the value in quotes for an exact match instead of a LIKE wildcard:
name:"John Smith"pii.email:"john@example.com"Presence check
Section titled “Presence check”Use * as the value to match any non-null entry:
pii.email:*extra.lat:*Combining terms
Section titled “Combining terms”Separate multiple terms with a comma. All terms are applied as AND conditions:
name:john, pii.email:@gmail.comname:"Jane Doe", pii.home_address:Texas, extra.lat:*Field reference
Section titled “Field reference”| Field | Type | Description |
|---|---|---|
uuid | text | Unique identifier for the record |
name | text | Full name |
socials | JSON | Social media handles and profile links |
pii.email | JSON field | Email address |
pii.phone | JSON field | Phone number (10-digit normalised) |
pii.home_address | JSON field | Physical address |
extra.lat | JSON field | Latitude (for map support) |
extra.lng | JSON field | Longitude (for map support) |