Filter Operators

{
    "field": "overdraftSettings.allowOverdraft",
    "operator": "EQUALS",
    "value": true
}

{
    "field": "name",
    "operator": "EQUALS_CASE_SENSITIVE",
    "value": "Daily Savings"
}

{
    "field": "balances.totalBalance",
    "operator": "MORE_THAN",
    "value": 500000.50
}

{
    "field": "accruedAmounts.interestAccrued",
    "operator": "LESS_THAN",
    "value": 10000.10
}

{
    "field": "balances.feesDue",
    "operator": "BETWEEN",
    "value": 100,
    "secondValue" : 500
}

{
    "field": "approvedDate",
    "operator": "ON",
    "value": "2021-06-15"
}

{
    "field": "lastModifiedDate",
    "operator": "AFTER",
    "value": "2022-04-20"
}

{
"field": "creationDate",
"operator": "BEFORE",
"value": "2021-12-25"
}

{
    "field": "creationDate",
    "operator": "BEFORE_INCLUSIVE",
    "value": "2020-06-15"
}

{
    "field": "id",
    "operator": "STARTS_WITH",
    "value":"eban"
}

{
    "field": "id",
    "operator": "STARTS_WITH",
    "value":"EBAN"
}

{
    "field": "accountType",
    "operator": "IN",
    "values":[
        "REGULAR_SAVINGS",
        "CURRENT_ACCOUNT"
    ]
}

{
    "field": "approvedDate",
    "operator": "TODAY"
}

{
    "field": "disbursementDetails.expectedDisbursementDate",
    "operator": "THIS_WEEK"
}

{
    "field": "lastPaymentDate",
    "operator": "THIS_MONTH"
}

{
    "field": "expectedMaturityDate",
    "operator": "THIS_YEAR"
}

{
    "field": "firstRepaymentDate",
    "operator": "LAST_DAYS",
    "value": 12
}

{
    "field": "overdraftRiskLevelKey",
    "operator": "EMPTY"
}

{
    "field": "lastSetToArrearsDate",
    "operator": "NOT_EMPTY"
}

The table below contains available operators as well as the types of field they are compatible with and the number of values they support.

Operator	Affected values	Available for
EQUALS	ONE_VALUE	BIG_DECIMAL, BOOLEAN, LONG, MONEY, NUMBER, PERCENT, STRING, ENUM, KEY
EQUALS_CASE_SENSITIVE	ONE_VALUE	STRING, BOOLEAN, DATE, NUMBER, ENUM, KEY
MORE_THAN	ONE_VALUE	BIG_DECIMAL, NUMBER, MONEY
LESS_THAN	ONE_VALUE	BIG_DECIMAL, NUMBER, MONEY
BETWEEN	TWO_VALUES	BIG_DECIMAL, NUMBER, MONEY, DATE, DATE_TIME
ON	ONE_VALUE	DATE, DATE_TIME
AFTER	ONE_VALUE	DATE, DATE_TIME
BEFORE	ONE_VALUE	DATE, DATE_TIME
BEFORE_INCLUSIVE	ONE_VALUE	DATE, DATE_TIME
STARTS_WITH	ONE_VALUE	STRING
STARTS_WITH_CASE_SENSITIVE	ONE_VALUE	STRING
IN	LIST	ENUM,KEY
TODAY	NO_VALUE	DATE, DATE_TIME
THIS_WEEK	NO_VALUE	DATE, DATE_TIME
THIS_MONTH	NO_VALUE	DATE, DATE_TIME
THIS_YEAR	NO_VALUE	DATE, DATE_TIME
LAST_DAYS	ONE_VALUE	NUMBER
EMPTY	NO_VALUE	BIG_DECIMAL, LONG, MONEY, NUMBER, PERCENT, STRING, ENUM, KEY, DATE, DATE_TIME
NOT_EMPTY	NO_VALUE	BIG_DECIMAL, LONG, MONEY, NUMBER, PERCENT, STRING, ENUM, KEY, DATE, DATE_TIME