Workflow packages
https://onesoftware.atlassian.net/spaces/OEN/pages/436469781/Workflow+packages
In this section
Package: validation
Package: mail
Package: mailer
Package: pos
Package: saltstack
Package: sharepoint
Package: boolean
Package: string
Package: awb
Package: word
Package: currency
Package: office
Package: companyInfo
Package: slack
Package: digitalsign
Package: decimal
Package: datetime
Package: link
Package: pdf
Package: system
Package: storage
Package: print
Package: event
Package: image
Package: entity
package: anaf
Cheat sheet
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
| Method | Since |
java<br>boolean->fromString(String string) as boolean<br> | 1.0 |
Decimal
| Method | Since |
java<br>decimal->fromString(input as string) as decimal<br> | 1.0 |
Int
| Method | Since |
java<br>int->fromDecimal(input as decimal) as int<br> | 1.0 |
java<br>int->fromString(input as string) as int<br> | 1.0 |
java<br>int->random() as int<br> | 1.0 |
java<br>int→randomWithBound(bound as int) as int<br> | 1.0 |
String
| Method | Since |
java<br>string->fromDecimal(BigDecimal decimal) as boolean<br> | 1.0 |
java<br>string->fromDateTime(DateTime dateTime) as string<br> | 1.0 |
java<br>string->isDateTime(String string) as boolean<br> | 1.0 |
java<br>string->isDecimal(String string) as boolean<br> | 1.0 |
java<br>string->isInt(String string) as boolean<br> | 1.0 |
java<br>string->replace(String target, String from, String to) as string<br> | 1.0 |
java<br>string->indexOf(String target, String search) as int<br> | 1.0 |
java<br>string->substring(String target, long start, long end) as string<br> | 1.0 |
java<br>string->trim(String target) as string<br> | 1.0 |
java<br>string->toLower(String target) as string<br> | 1.4 |
java<br>string->toUpper(String target) as string<br> | 1.4 |
java<br>string->length(String target) as int<br> | 1.4 |
java<br>string->split(String target, String splitter) as collection of string<br> | 1.4 |
java<br>string->contains(String target, String search) as boolean<br> | 1.4 |
java<br>string->startsWith(String target, String search) as boolean<br> | 1.4 |
java<br>string->endsWith(String target, String search) as boolean<br> | 1.4 |
System
| Method | Since |
java<br>system->error(String message)<br> | 1.0 |
java<br>system->getCurrentUser() as user<br> | 1.0 |
java<br>system->sequence(long start, long stop, long increment) as int<br> | 1.0 |
java<br>system->digest(String message) as string<br> | 1.0 |
java<br>system->flushCache()<br> | 1.0 |
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 |
java<br>math->abs(input as decimal) as decimal<br> | 1.0 |
java<br>math->round(input as decimal, precision as int) as decimal<br> | 1.0 |
java<br>math->pow(base as decimal, int exponent) as decimal<br> | 1.0 |
java<br>math->sqrt(input as decimal) as decimal<br> | 1.0 |
java<br>math->log(input as decimal) as decimal<br> | 1.7.2 |
java<br>math->log10(input as decimal) as decimal<br> | 1.7.2 |
Math logBase example
function atomic logBase(logNumber as decimal, base as decimal) as decimal {
return math->log(logNumber) / math->log(base);}
Validation
| Method | Since |
java<br>validation->reject(String entityName, String propertyName, String message)<br> | 1.0 |
| Method | Since |
java<br>mail->send(to as string, subject as string, body as string)<br> | 1.0 |
java<br>mail->isValidAddress(address as string)<br> | 1.0 |
java<br>mail->sendFile(to as string, subject as string, body as string, idStorageFile as int)<br> | 1.0 |
Office
| Method | Since |
java<br>office->getNoOfSheets(wb as workbook) as int<br> | 1.0 |
java<br>office->getNoOfRows(wb as workbook, sheetNo as int) as int<br> | |
java<br>office->getCellDecimal(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as decimal<br> | |
java<br>office->getCellDate(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as datetime<br> | |
java<br>office->getCellString(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string<br> | |
java<br>office->getCellBoolean(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as boolean<br> | 1.4 |
java<br>office->getCellFormula(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string<br> | 1.4 |
java<br>office->getCellType(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as int<br> | 1.4 |
java<br>office->evaluateCell(wb as workbook, sheetNo as int, rowNo as int, cellNo as int) as string<br> | 1.4 |
java<br>office->setCellDecimal(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as decimal)<br> | |
java<br>office->setCellDate(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as datetime)<br> | |
java<br>office->setCellString(wb as workbook, sheetNo as int, rowNo as int, cellNo as int, value as string)<br> | |
java<br>office->setCellFormula(wb as workbook, sheetNo as int, long rowNo, long colNo, value as string)<br> | |
java<br>office->toColumnName(colNo as int) as string<br> | |
java<br>office->toCellName(rowNo as int, colNo as int) as string<br> | |
java<br>office->save(wb as workbook, fileName as string) as int<br> | |
java<br>office->update(wb as workbook, fileName as string, key as int) as int<br> | |
java<br>office->open(key as int) as int<br> | 1.4 |