Skip to main content

Clientfiltercriteria

The unit that composes the list used for Clients searching

fieldstringrequired

The fields to perform the search. They can be native (one from the provided list) or otherwise can specify a custom field definition using the format [customFieldSetId].[customFieldId].

Possible values: [encodedKey, creditOfficerKey, clientRoleKey, branchKey, centreKey, groupKey, fullName, firstName, middleName, lastName, creationDate, lastModifiedDate, id, depositsBalance, loansBalance, pendingLoanAmount, approvedLoanAmount, totalBalance, totalDue, homePhoneNumber, mobilePhoneNumber, mobilePhoneNumber2, emailAddress, clientAddress, birthdate, gender, loanCycle, groupLoanCycle, clientState, portalState, preferredLanguage, groupId]

operatorstringrequired
OperatorAffected valuesAvailable for
EQUALSONE_VALUEBIG_DECIMAL,BOOLEAN,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY
EQUALS_CASE_SENSITIVEONE_VALUEBIG_DECIMAL,BOOLEAN,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY
MORE_THANONE_VALUEBIG_DECIMAL,NUMBER,MONEY
LESS_THANONE_VALUEBIG_DECIMAL,NUMBER,MONEY
BETWEENTWO_VALUESBIG_DECIMAL,NUMBER,MONEY,DATE,DATE_TIME
ONONE_VALUEDATE,DATE_TIME
AFTERONE_VALUEDATE,DATE_TIME
BEFOREONE_VALUEDATE,DATE_TIME
BEFORE_INCLUSIVEONE_VALUEDATE,DATE_TIME
STARTS_WITHONE_VALUESTRING
STARTS_WITH_CASE_SENSITIVEONE_VALUESTRING
INLISTENUM,KEY
TODAYNO_VALUEDATE,DATE_TIME
THIS_WEEKNO_VALUEDATE,DATE_TIME
THIS_MONTHNO_VALUEDATE,DATE_TIME
THIS_YEARNO_VALUEDATE,DATE_TIME
LAST_DAYSONE_VALUENUMBER
EMPTYNO_VALUEBIG_DECIMAL,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY,DATE,DATE_TIME
NOT_EMPTYNO_VALUEBIG_DECIMAL,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY,DATE,DATE_TIME

Possible values: [EQUALS, EQUALS_CASE_SENSITIVE, DIFFERENT_THAN, MORE_THAN, LESS_THAN, BETWEEN, ON, AFTER, AFTER_INCLUSIVE, BEFORE, BEFORE_INCLUSIVE, STARTS_WITH, STARTS_WITH_CASE_SENSITIVE, IN, TODAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_DAYS, EMPTY, NOT_EMPTY]

secondValuestring

The second value to match the searching criteria, when the BETWEEN operator is used.

valuestring

The value to match the searching criteria.

valuesstring[]

List of values when the IN operator is used.

Clientfiltercriteria
{
"field": "encodedKey",
"operator": "EQUALS",
"secondValue": "string",
"value": "string",
"values": [
"string"
]
}