Comparison Operations

These operations are designed for numeric, date, and string comparisons. They're essential for filtering data by ranges and relative values.

Greater Than (gt)

Finds records where the field value is greater than the specified value.

Syntax

field__gt=value

Examples

# Accounts with balance greater than 1000
GET /api/v0/accounts?balance__gt=1000

# Positions opened after a specific time
GET /api/v0/trade/positions?openTime__gt=2024-01-01

# Groups with more than 5 accounts
GET /api/v0/groups?accountsCount__gt=5

Greater Than or Equal (ge)

Finds records where the field value is greater than or equal to the specified value.

Syntax

field__ge=value

Examples

# Accounts with balance of 1000 or more
GET /api/v0/accounts?balance__ge=1000

# Accounts created this year or later
GET /api/v0/accounts?createdAt__ge=2024-01-01

# Groups with at least 1 account
GET /api/v0/groups?accountsCount__ge=1

Less Than (lt)

Finds records where the field value is less than the specified value.

Syntax

field__lt=value

Examples

# Accounts with balance less than 5000
GET /api/v0/accounts?balance__lt=5000

# Positions with small volume
GET /api/v0/trade/positions?volumeCurrent__lt=1.0

# Recent records only
GET /api/v0/accounts?createdAt__lt=2024-12-31

Less Than or Equal (le)

Finds records where the field value is less than or equal to the specified value.

Syntax

field__le=value

Examples

# Accounts with balance up to 10000
GET /api/v0/accounts?balance__le=10000

# Positions with volume of 5.0 or less
GET /api/v0/trade/positions?volumeCurrent__le=5.0

# Historical data up to a date
GET /api/v0/trade/histories?closeTime__le=2024-06-30

Range Filtering

Combine ge and le operations to create range filters:

# Accounts with balance between 1000 and 5000
GET /api/v0/accounts?balance__ge=1000&balance__le=5000

# Positions opened this year
GET /api/v0/trade/positions?openTime__ge=2024-01-01&openTime__le=2024-12-31

# Medium-sized groups
GET /api/v0/groups?accountsCount__ge=5&accountsCount__le=50

Field Type Support

These operations work with:

• Numeric Types: Integer, Long, Float, Double, BigDecimal

• Date/Time Types: Date, LocalDate, LocalDateTime, Timestamp

• String Types: Alphabetical comparison

Date Format

When using comparison operations with dates, use this format:

• Dates: yyyy-MM-dd (e.g., 2024-01-01)

• DateTime: ISO format (e.g., 2024-01-01T10:30:00)

Next Steps

• Explore Calculated Fields for special group operations

• Learn about Field Types for detailed type support information