Loanaccountsearchcriteria

Wrapper that holds a list of filtering criteria and a sorting criteria for Loan account directed query

filterCriteria object[]

The list of filtering criteria

Array [

fieldstringrequired

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]

operatorstringrequired

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]

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.

]

sortingCriteria object

Represents the sorting criteria used for loan account searches.

fieldstringrequired

Contains the field that can be used as sorting selection. Can be native (one from the provided list) or otherwise can specify a custom field definition using the format [customFieldSetId].[customFieldId].

Possible values: [encodedKey, loanName, id, accountHolderId, recipient, creationDate, approvedDate, lastModifiedDate, lastSetToArrearsDate, lastLockedDate, closedDate, daysInArrears, daysLate, loanAmount, tranches.amount, numInstallments, accruedInterest, accruedPenalty, penaltySettings.penaltyRate, arrearsTolerancePeriod, interestSettings.interestSpread, totalPaid, totalBalance, totalDue, firstRepaymentDate, lastPaymentDate, lastPaymentAmount, expectedMaturity, rescheduledAccountKey, refinancedAccountId, originalAccountKey, taxRate, taxPaid, taxDue, settlementAccountKey, interestCommission, numberOfFunds, fundsEnabled, availableAmount, wasRescheduled, wasRefinanced, expectedPrincipalRedraw, balances.principalDue, balances.principalPaid, balances.principalBalance, balances.interestDue, balances.interestPaid, balance.interestBalance, balances.redrawBalance, balances.feesDue, balances.feesBalance, balances.feesPaid, balances.penaltyDue, balances.penaltyPaid, balances.penaltyBalance, fundingSources.amount, fundingSources.sharePercentage]

orderstring

The sorting order: ASC or DESC. The default order is DESC.

Possible values: [ASC, DESC]

Loanaccountsearchcriteria

{
  "filterCriteria": [
    {
      "field": "accountHolderKey",
      "operator": "EQUALS",
      "secondValue": "string",
      "value": "string",
      "values": [
        "string"
      ]
    }
  ],
  "sortingCriteria": {
    "field": "encodedKey",
    "order": "ASC"
  }
}