Available Functions

DB Fetching

GetDbList

{GetDbList [FromTable: Charge Columns: ChargeAmount Where: ApplicationID = CurrentApplication]}
{GetDbList[ FromTable: Document Columns: DocumentID, ApplicationID, SubType:Name, SubType:DocType:Name > TypeName, size Where: size>2000 Filter: TypeName = 'Executed Agreements' DefaultFilter: true ShowSql: false]}
Accessing Child Class and Joining related tables properties
{GetDbList [FromTable: Charge.SubjectCharge Columns: ApplicationID, Application.Name, ChargeAmount Where: ApplicationID=CurrentApplication]} Into: appCharges]}
nested functions
The pdf documents that are currently stored in the DB: {GetDbList [FromTable: Document Columns: Name Where: DocFormatID={GetDbList [FromTable: DocFormat Where: Extension='.pdf' ]}.First[].DocFormatID ]}

GetValue

{GetValue [Record: {Single Object} Column: {Single Colum}]}
{GetValue [Record: {First [ {GetDbList [FromTable: Application Columns: ApplicationID, Name, CreatedDate Where: ApplicationID=CurrentApplication ]} ]} Column: CreatedDate]}"

GetEnum

{GetEnumValue [Enum: ChargeToNamedEntityRelationshipEnum Selection: Guarantor ]}
{GetEnumName [Enum: ChargeToNamedEntityRelationshipEnum Selection: 1 ]}

Accessing SubType

{ForEach [ec Of: {GetDbList [Charge.SubjectCharge,*,]} {Do [ec | ]} ]}

Fetching nested properties

{GetDbList [FromTable: Document Columns: Name, Format.Extension, Application.Name, Application.LeadClientGroup.Name, CreatorName]}

GetEnumValue

{GetEnumValue [Enum: ChargeToNamedEntityRelationshipEnum Selection: Borrower ]}
Available options: BeneficialOwner, Borrower, Guarantor, Indemnitor
{GetEnumValue [Enum: RecourseLevelEnum Selection: Full ]}
Available options: Full, LimitedOnJoint, LimitedOnSeveralBasis, None

Count, Sum, First

{Count[{GetDbList[FromTable:Charge.SubjectCharge Where: ApplicationID=CurrentApplication]} ]}
{sum[Data:'[3,6.3,8]']}
'[3,6.3,8]'.sum[]

Calculations

Compute

{Compute [ (2 - 3)*2 ]}

Add

The Sum of 4 and 5 is {Add[4,5]} '[5,7,54]'.Sum[]

Subtract

The Substraction of 9 and 5 is {Subtract[9,5]}

Multiplocation

{Mul[4.5,3.2]}
'[4.5,3.2]'.Mul[]

Devision

{Devide[4.5,3.2]}
'[4.5,3.2]'.Devide[]

Quoting

The first is{First['[{"ID":1,"Name":"Guy"},{"ID":2,"Name":"Dave"}]']}

Itirating

{ForEach [docFormatRecord Of: {GetDbList[DocFormat,*,]} {Do [docFormatRecordIndex: DocFormatrecord | ]} ]}

Variables

Storing Variable

{GetDbList [FromTable: Document Columns:* Into: myDocuments]} {GetDbList [FromTable: Application Columns:* Into: myApplications]} and now here is the stored variable {GetVar[myDocuments]}
{StoreVar [Value: {GetDbList [FromTable: Charge.SubjectCharge Columns: ChargeAmount]} Into: myChargeAmounts ]}

using variable

{GetVar[myChargeAmounts]}

Outputs

Output Value

{OutputValue[{GetValue [Record: {First [ {GetDbList [FromTable: Application Columns: ApplicationID, Name, CreatedDate Where: ApplicationID=CurrentApplication ]} ]} Column: CreatedDate]} ]}

Output List

{OutputList[ List: {GetDbList [FromTable: Application Columns: Name ]} Delimiter: | ]}
{OutputList[ List: {GetDbList [FromTable: Application Columns: Name ]} Delimiter: , ]}

Output Table

Here we are storing an object {StoreVar [Value: {GetDbList [FromTable: Charge.SubjectCharge Columns: Application.Name, ChargeAmount]} Into: myChargeAmounts ]} and here we are using the stored variable {OutputTable [Data: {GetVar[myChargeAmounts]}]}
{OutputTable [Data: {GetDbList [FromTable: Charge.SubjectCharge Columns: ChargeAmount, ChargePriorityID Where: ApplicationID=CurrentApplication And SnapshotID=0]} ]}

Conditions

{CheckIf [5>4.3 Or 2>3]}
{CheckIf [5>4.3 Or 2>3]} {CheckIf [ {GetValue [Record: {First [ {GetDbList [FromTable: Application Columns: ApplicationID, Name, CreatedDate Where: ApplicationID=CurrentApplication ]} ]} Column: CreatedDate]} > "3/2/2018" ]}
{DoIf [ 4>3 {DoOnTrue[ hello]} {DoOnFalse[Goodbye]} ]}

Using Stored Procedures Calculations

{GetCalc [GetCommercialRentRoll Params:3397,0]}.OutputTable[]

Comonly Used Shortcuts

{GetCurrentSubjectCharge[]}
{GetCurrentSubjectChargeID[]}
{GetStages[]}
{GetCurrentStage[]}
{GetDate[]}
{GetDate[time Zone Code]}   time-zones-list
{Period [ 3/3/12 - 9/9/16 Unit: year]}
{Period[ {GetDate[]} - 3/3/2015 Unit: month]}

Examples

The Borrowers for the Applications Are: | {OutputList[ List:{ GetDbList[FromTable: ChargeToNamedEntity Columns: NamedEntity.Name Where: ChargeToNamedEntityRelationship = {GetEnumValue [Enum: ChargeToNamedEntityRelationshipEnum Selection: Borrower ]} And SubjectChargeID = {GetCurrentSubjectChargeID[]} ]} Delimiter: , ]} || And the BeneficialOwners are: | {OutputList[ List:{ GetDbList[FromTable: ChargeToNamedEntity Columns: NamedEntity.Name Where: ChargeToNamedEntityRelationship = {GetEnumValue [Enum: ChargeToNamedEntityRelationshipEnum Selection: BeneficialOwner ]} And SubjectChargeID = {GetCurrentSubjectChargeID[]} ]} Delimiter: , ]}

Charge Count: | External Charge: {Count[{GetDbList[FromTable: Charge.ExternalCharge Where: ApplicationID=CurrentApplication]} ]} | SubjectCharge: {Count[{GetDbList[FromTable:Charge.SubjectCharge Where: ApplicationID=CurrentApplication]} ]}
Fetching, Storing and Summerizing
{GetDbList [FromTable: Charge.SubjectCharge Columns: ChargeID, Application.Name, ChargeAmount Where: ApplicationID=CurrentApplication]}.StoreVar[Into: mySubjectChargeList]}
{GetVar[mySubjectChargeList]}.OutputTable[]
{GetVar[mySubjectChargeList]}.OutputList[Delimiter: ,|]
Total No Of SubjectCharge: {GetVar[mySubjectChargeList]}.Count[] | Total Sum: {GetVar[mySubjectChargeList]}.ChargeAmount.Sum[]

Importing queries and producing Tabales


{GetKeySummaryTable[requestedTable]}.Format[Table Headers: Fee Name, Amount ColFormat: Percentage, String, Money]
{GetCalc [GetCommercialRentRoll Params:3397,0]}.OutputTable[]
{GetQueryList[FromQuery: GetTransactionDashboard Columns: Stage,Payee, Payor Where: TransactionID = 355 ]}

Creating Dynamic Objects and Tables + Filtering


NewRecord[Counter:: 1,, Name:: Guy,, Quantity:: {Add[4,3]} ]}.AddToList[Into: Names]
{NewRecord[Counter::2,, Name::Robbie,, Quantity:: {Subtract [10,5]}]}.AddToList[Into: Names]
{GetVar[Names]}.Filter[Columns: Name Where: Quantity>6 ]

Getting letters definition


{GetLetterDefinition[CL]}
{GetLetterDefinition[CL Raw: True]}

Getting Application Stages Status


{GetStages[]}}
{getCurrentStage[]}

Warnings


GetDbList[FromTable: WarningGroup]}.Name
{RunWarningCheck[FundsWarnings]}.OutputTable[]
{RunWarningCheckList[checkListName]}.OutputTable[]

Transpose

Multi level nested object

{GetKeySummaryTable[GetInterMediaryProfitability UnFormat:True]}.Transpose[Key: ProfitabilityLabel]

Flat value single object

{GetKeySummaryTable[GetInterMediaryProfitability UnFormat:True]}.Transpose[Key: ProfitabilityLabel, Value:Dollars]