activity (switch)
Applies when
type = switch| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
name | string | Yes | data type=string; maxLen=255Enter a name for the workflow activity. | |
type | enum | Yes | data type=string; lov=PLUGINSValid values: switch |
switch
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | trueFalseCheck | data type=string; maxLen=4000; lov=STATICValid values: case trueFalseCheck checkWorkflowVar if |
switch {
type: case
}compare
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
dataType | enum | Yes | varchar2 | data type=string; maxLen=4000; lov=STATICValid values: boolean timestampWithTimeZone timestamp timestampWithLocalTimeZone number varchar2Applies when type = CASE |
compareType | enum | Yes | sqlQuery | data type=string; maxLen=4000; lov=STATICValid values: functionBody sqlQuery expressionApplies when type = CASE |
compareVar | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = CHECK_WF_VARIABLE | |
compareSqlQuery | string | Yes | data type=string; maxLen=4000Applies when type = CASE and compare_type = SQL_QUERY | |
comparePlsqlExpression | string | Yes | data type=string; maxLen=4000Applies when type = CASE and compare_type = EXPRESSION | |
comparePlsqlFunctionBody | string | Yes | data type=string; maxLen=4000Applies when type = CASE and compare_type = FUNCTION_BODY | |
compareLanguage | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql js-mleApplies when type = CASE and compare_type in (EXPRESSION)type = CASE and compare_type in (FUNCTION_BODY) |
compare {
dataType: boolean
compareType: functionBody
compareVar: value
compareSqlQuery: value
comparePlsqlExpression: value
comparePlsqlFunctionBody: value
compareLanguage: plsql
}condition
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
conditionType | enum | Yes | rowsReturned | data type=string; maxLen=4000; lov=STATICValid values: workflowVarIsNotNull rowsReturned workflowVarNotEqualsValue workflowVarIsNull rowsNotReturned workflowVarEqualsValue expression functionBodyApplies when type = TRUE_FALSE_CHECK |
sqlQuery | string | Yes | data type=string; maxLen=4000Applies when type = TRUE_FALSE_CHECK and condition_type in (ROWS_RETURNED)type = TRUE_FALSE_CHECK and condition_type in (ROWS_NOT_RETURNED) | |
plsqlExpression | string | Yes | data type=string; maxLen=4000Applies when type = TRUE_FALSE_CHECK and condition_type = EXPRESSION | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql js-mleApplies when type = TRUE_FALSE_CHECK and condition_type in (EXPRESSION)type = TRUE_FALSE_CHECK and condition_type in (FUNCTION_BODY) |
plsqlFunctionBody | string | Yes | data type=string; maxLen=4000Applies when type = TRUE_FALSE_CHECK and condition_type = FUNCTION_BODY | |
workflowVar | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = TRUE_FALSE_CHECK and condition_type in (WF_VARIABLE_NULL)type = TRUE_FALSE_CHECK and condition_type in (WF_VARIABLE_NOT_NULL)type = TRUE_FALSE_CHECK and condition_type in (WF_VARIABLE_EQ_VAL)type = TRUE_FALSE_CHECK and condition_type in (WF_VARIABLE_NEQ_VAL) | |
value | string | Yes | data type=string; maxLen=4000Applies when type = TRUE_FALSE_CHECK and condition_type in (WF_VARIABLE_EQ_VAL)type = TRUE_FALSE_CHECK and condition_type in (WF_VARIABLE_NEQ_VAL) |
condition {
conditionType: workflowVarIsNotNull
sqlQuery: value
plsqlExpression: value
language: plsql
plsqlFunctionBody: value
workflowVar: value
value: value
}genAI
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=boolean |
agent | reference | No | data type=reference; lov=COMPONENT; references=aiAgentApplies when enabled = true | |
service | reference | No | data type=reference; lov=COMPONENT; references=genAIServiceApplies when enabled = true | |
systemPrompt | multiline string | No | data type=multiline string; maxLen=32767Applies when enabled = true |
genAI {
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
}source
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
location | enum | Yes | localDatabase | data type=string; lov=STATICValid values: localDatabase restEnabledSql |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when location = localDatabase |
plsqlCode | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = localDatabase and language = plsql | |
javaScriptCode | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = localDatabase and language = javaScript-mle | |
remoteServer | reference | Yes | data type=reference; lov=COMPONENT; references=restEnabledSqlDatabaseApplies when location = restEnabledSql | |
plsqlCode | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = restEnabledSqlEnter the PL/SQL code to be executed on the remote database. |
source {
location: localDatabase
language: plsql
plsqlCode: ```plsql
value
```
javaScriptCode: ```javascript-mle
value
```
remoteServer: @component
}additionalData
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sqlQuery | multiline string | No | data type=multiline string; maxLen=4000Enter a SQL query to read additional data. The column names of the query can be used as bind variables and substitution strings to evaluate conditions or activity variables during the execution of the activity. The result of the query should contain only one row. If the query returns no result or more than one row then the activity fails during execution. |
additionalData {
sqlQuery: ```sql
value
```
}deadline
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
dueOnType | enum | No | data type=string; lov=STATICValid values: interval sqlQuery expression functionBody schedulerExpression | |
interval | string | Yes | data type=string; maxLen=255Applies when dueOnType = interval | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when dueOnType = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when dueOnType = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = functionBody and language = javaScript-mle | |
schedulerExpression | multiline string | Yes | data type=multiline string; maxLen=255Applies when dueOnType = schedulerExpression |
deadline {
dueOnType: interval
interval: value
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
schedulerExpression: ```
value
```
}layout
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22 |
layout {
sequence: 42
}parallelFlow
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
branch | reference | No | data type=reference; lov=COMPONENT; references=branch |
parallelFlow {
branch: @component
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
staticId | string | Yes | data type=string; maxLen=255 | |
label | string | No | data type=string; maxLen=4000 | |
diagram | string | No | data type=string; maxLen=32767 |
advanced {
staticId: value
label: value
diagram: value
}comments
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
comments | multiline string | No | data type=multiline string; maxLen=4000 |
comments {
comments: ```
value
```
}APEXlang Example
activity sample (
name: value
type: switch
switch {
type: case
}
compare {
dataType: boolean
compareType: functionBody
compareVar: value
compareSqlQuery: value
comparePlsqlExpression: value
comparePlsqlFunctionBody: value
compareLanguage: plsql
}
condition {
conditionType: workflowVarIsNotNull
sqlQuery: value
plsqlExpression: value
language: plsql
plsqlFunctionBody: value
workflowVar: value
value: value
}
genAI {
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
}
source {
location: localDatabase
language: plsql
plsqlCode: ```plsql
value
```
javaScriptCode: ```javascript-mle
value
```
remoteServer: @component
}
additionalData {
sqlQuery: ```sql
value
```
}
deadline {
dueOnType: interval
interval: value
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
schedulerExpression: ```
value
```
}
layout {
sequence: 42
}
parallelFlow {
branch: @component
}
advanced {
staticId: value
label: value
diagram: value
}
comments {
comments: ```
value
```
}
)