Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Cheat sheet

System

Package: system

Method

Since

system->error(message as string)

1.0

system->digest(message as string) as string

1.0

system->sequence(start as int, count as int, step as int) as collection of int

1.0

system->randomUUID() as string

1.4

Boolean

Package: boolean

Method

Since

Code Block
boolean->fromString(String string) as boolean

1.0

Decimal

Method

Since

Code Block
decimal->fromString(input as string) as decimal

1.0

Int

Method

Since

Code Block
int->fromDecimal(input as decimal) as int

1.0

Code Block
int->fromString(input as string) as int

1.0

Code Block
int->random() as int

1.0

Code Block
int→randomWithBound(bound as int) as int

1.0

String

Package: string

Method

Since

Code Block
string->fromDecimal(BigDecimal decimal) as boolean

1.0

Code Block
string->fromDateTime(DateTime dateTime) as string

1.0

Code Block
string->isDateTime(String string) as boolean

1.0

Code Block
string->isDecimal(String string) as boolean

1.0

Code Block
string->isInt(String string) as boolean

1.0

Code Block
string->replace(String target, String from, String to) as string

1.0

Code Block
string->indexOf(String target, String search) as int

1.0

Code Block
string->substring(String target, long start, long end) as string

1.0

Code Block
string->trim(String target) as string

1.0

Code Block
string->toLower(String target) as string

1.4

Code Block
string->toUpper(String target) as string

1.4

Code Block
string->length(String target) as int

1.4

Code Block
string->split(String target, String splitter) as collection of string

1.4

Code Block
string->contains(String target, String search) as boolean

1.4

Code Block
string->startsWith(String target, String search) as boolean

1.4

Code Block
string->endsWith(String target, String search) as boolean

1.4

System

Package: system

Method

Since

Code Block
system->error(String message)

1.0

Code Block
system->getCurrentUser() as user

1.0

Code Block
system->sequence(long start, long stop, long increment) as int

1.0

Code Block
system->digest(String message) as string

1.0

Code Block
system->flushCache()

1.0

Datetime

Package: datetime

Method

Since

datetime->fromString(input as string) as datetime

1.0

datetime->now() as datetime

1.4

datetime->plusSeconds(date as datetime, increment as int) as datetime

1.4

datetime->plusMinutes(date as datetime, increment as int) as datetime

1.4

datetime->plusHours(date as datetime, increment as int) as datetime

1.4

datetime->plusDays(date as datetime, increment as int) as datetime

1.4

datetime->plusWeeks(date as datetime, increment as int) as datetime

1.4

datetime->plusMonths(date as datetime, increment as int) as datetime

1.4

datetime->plusYears(date as datetime, increment as int) as datetime

1.4

datetime->lastDayOfMonth(date as datetime) as int

1.4

datetime->year(date as datetime) as int

1.4

datetime->month(date as datetime) as int

1.4

datetime->day(date as datetime) as int

1.4

datetime->hour(date as datetime) as int

1.4

datetime->minute(date as datetime) as int

1.4

datetime->daysBetween(date1 as datetime, date2 as datetime) as int

1.4

datetime->dayOfWeek(date as datetime) as int

1.4

datetime->dayOfMonth(date as datetime) as int

1.4

datetime->dayOfYear(date as datetime) as int

1.4

Math

Method

Since

Code Block
math->abs(input as decimal) as decimal

1.0

Code Block
math->round(input as decimal, precision as int) as decimal

1.0

Code Block
math->pow(base as decimal, int exponent) as decimal

1.0

Code Block
math->sqrt(input as decimal) as decimal

1.0

Code Block
math->log(input as decimal) as decimal

1.7.2

Code Block
math->log10(input as decimal) as decimal

1.7.2

Validation

Method

Since

Code Block
validation->reject(String entityName, String propertyName, String message)

1.0

Mail

Package: mail

Method

Since

Code Block
mail->send(to as string, subject as string, body as string)

1.0

Code Block
mail->isValidAddress(address as string)

1.0

Code Block
mail->sendFile(to as string, subject as string, body as string, idStorageFile as int)

1.0

Office

Method

Since

Code Block
office->getNoOfSheets(wb as workbook) as int

1.0

Code Block
office->getNoOfRows(wb as workbook, sheetNo as int) as int

Code Block
office->getCellDecimal(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as decimal

Code Block
office->getCellDate(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as datetime

Code Block
office->getCellString(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string

Code Block
office->getCellBoolean(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as boolean

1.4

Code Block
office->getCellFormula(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string

1.4

Code Block
office->getCellType(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as int

1.4

Code Block
office->evaluateCell(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string

1.4

Code Block
office->setCellDecimal(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as decimal)

Code Block
office->setCellDate(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as datetime)

Code Block
office->setCellString(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as string)

Code Block
office->setCellFormula(wb as workbook, sheetNo as int, long rowNo, long colNo, value as string)

Code Block
office->toColumnName(colNo as int) as string

Code Block
office->toCellName(rowNo as int, colNo as int) as string

Code Block
office->save(wb as workbook, fileName as string) as int

Code Block
office->update(wb as workbook, fileName as string, key as int) as int

Code Block
office->open(key as int) as int

1.4