Basic Operations

These are the fundamental search operations that work with all field types. They form the foundation of the search system.

Equals (eq)

The default operation for exact matching.

Syntax

field=value
# OR
field__eq=value

Examples

# Find account with exact name
GET /api/v0/accounts?name=John

# Find account with specific ID
GET /api/v0/accounts?id__eq=123

Not Equals (ne)

Excludes records that match the specified value.

Syntax

field__ne=value

Examples

# Find all accounts except inactive ones
GET /api/v0/accounts?status__ne=inactive

# Exclude specific group
GET /api/v0/accounts?group.name__ne=Demo

Contains (like)

Case-insensitive substring matching. Perfect for search-as-you-type functionality.

Syntax

field__like=value

Examples

# Find accounts with names containing "john"
GET /api/v0/accounts?name__like=john

# Search for groups containing "admin"
GET /api/v0/groups?name__like=admin

In List (in)

Matches any value from a comma-separated list.

Syntax

field__in=value1,value2,value3

Examples

# Find specific account IDs
GET /api/v0/accounts?id__in=1,2,3,4,5

# Filter by multiple statuses
GET /api/v0/accounts?status__in=active,pending

# Multiple trade directions
GET /api/v0/trade/positions?direction__in=BUY,SELL

Usage Tips

• Exact matching: Use eq (or just field=value) when you need precise matches

• Search functionality: Use like for user search inputs

• Exclusion: Use ne to filter out unwanted records

• Multiple values: Use in when you need to match several possible values

Next Steps

• Learn about Comparison Operations for numeric and date filtering

• Explore Field Types to understand which operations work with your data