Loanaccountfiltercriteria
Wrapper that holds a list of filtering criteria and a sorting criteria for Loan account directed query
Contains the actual searching fields that can be native (one from the provided list) or otherwise can specify a custom field definition using the format [customFieldSetId].[customFieldId].
Possible values: [accountHolderKey, assignedBranchKey, productTypeKey, loanRiskLevelKey, encodedKey, loanName, id, accountHolderId, recipient, creationDate, approvedDate, lastModifiedDate, lastSetToArrearsDate, lastLockedDate, closedDate, daysInArrears, daysLate, accountSubState, accountState, loanAmount, numInstallments, balances.principalDue, balances.principalPaid, balances.principalBalance, balances.interestDue, balances.interestPaid, balance.interestBalance, accruedInterest, balances.feesDue, balances.feesBalance, balances.feesPaid, penaltySettings.loanPenaltyCalculationMethod, balances.penaltyDue, balances.penaltyPaid, balances.penaltyBalance, accruedPenalty, penaltySettings.penaltyRate, arrearsTolerancePeriod, interestSettings.interestRate, interestSettings.interestSpread, totalPaid, totalBalance, totalDue, firstRepaymentDate, lastPaymentDate, lastPaymentAmount, expectedMaturityDate, rescheduledAccountKey, refinancedAccountId, originalAccountKey, taxRate, taxPaid, taxDue, settlementAccountKey, interestCommission, fundingSources.amount, fundingSources.sharePercentage, numberOfFunds, fundsEnabled, availableAmount, wasRescheduled, wasRefinanced, prepaymentSettings.prepaymentRecalculationMethod, prepaymentSettings.applyInterestOnPrepaymentMethod, latePaymentsRecalculationMethod, balances.redrawBalance, expectedPrincipalRedraw, tranches.parentAccountKey, tranches.disbursementDetails.disbursementTransactionKey, tranches.amount, tranches.disbursementDetails.expectedDisbursementDate, disbursementDetails.expectedDisbursementDate, disbursementDetails.disbursementDate, lastAccountAppraisalDate]
| Operator | Affected values | Available for |
|---|---|---|
| EQUALS | ONE_VALUE | BIG_DECIMAL,BOOLEAN,LONG,MONEY,NUMBER,PERCENT,STRING,ENUM,KEY |
| EQUALS_CASE_SENSITIVE | ONE_VALUE | BIG_DECIMAL,BOOLEAN,LONG,MONEY,NUMBER,PERCENT,STRING,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 |
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]
The second value to match the searching criteria, when the BETWEEN operator is used.
The value to match the searching criteria.
List of values when the IN operator is used.
{
"field": "accountHolderKey",
"operator": "EQUALS",
"secondValue": "string",
"value": "string",
"values": [
"string"
]
}