activity (wait)

Parent: activity

Applies whentype = wait

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
namestringYesdata type=string; maxLen=255
Enter a name for the workflow activity.
typeenumYesdata type=string; lov=PLUGINS
Valid values: wait

Property Groups:

  • timeout
  • genAI
  • source
  • additionalData
  • deadline
  • layout
  • parallelFlow
  • advanced
  • comments
timeout
PropertyTypeRequiredDefault ValueDetails
timeoutTypeenumNodata type=string; maxLen=4000; lov=STATIC
Valid values: static expression sqlQuery functionBody
sqlQuerystringYesdata type=string; maxLen=4000
Applies whentimeout_type = SQL_QUERY
plsqlExpressionstringYesdata type=string; maxLen=4000
Applies whentimeout_type = EXPRESSION and lang_expression = PLSQL
plsqlFunctionBodystringYesdata type=string; maxLen=4000
Applies whentimeout_type = FUNCTION_BODY and lang_function_body = PLSQL
staticValuestringYesdata type=string; maxLen=4000
Applies whentimeout_type = STATIC
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql js-mle
Applies whentimeout_type = EXPRESSION
javascriptExpressionstringYesdata type=string; maxLen=4000
Applies whentimeout_type = EXPRESSION and lang_expression = JAVASCRIPT
javascriptFunctionBodystringYesdata type=string; maxLen=4000
Applies whentimeout_type = FUNCTION_BODY and lang_function_body = JAVASCRIPT
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql js-mle
Applies whentimeout_type = FUNCTION_BODY
timeout {
  timeoutType: static
  sqlQuery: value
  plsqlExpression: value
  plsqlFunctionBody: value
  staticValue: value
  language: plsql
  javascriptExpression: value
  javascriptFunctionBody: value
}
genAI
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
agentreferenceNodata type=reference; lov=COMPONENT; references=aiAgent
Applies whenenabled = true
servicereferenceNodata type=reference; lov=COMPONENT; references=genAIService
Applies whenenabled = true
systemPromptmultiline stringNodata type=multiline string; maxLen=32767
Applies whenenabled = true
genAI {
  enabled: false
  agent: @component
  service: @component
  systemPrompt: ```
    value
  ```
}
source
PropertyTypeRequiredDefault ValueDetails
locationenumYeslocalDatabasedata type=string; lov=STATIC
Valid values: localDatabase restEnabledSql
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenlocation = localDatabase
plsqlCodemultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = localDatabase and language = plsql
javaScriptCodemultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = localDatabase and language = javaScript-mle
remoteServerreferenceYesdata type=reference; lov=COMPONENT; references=restEnabledSqlDatabase
Applies whenlocation = restEnabledSql
plsqlCodemultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = restEnabledSql
Enter 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
PropertyTypeRequiredDefault ValueDetails
sqlQuerymultiline stringNodata type=multiline string; maxLen=4000

Enter 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
PropertyTypeRequiredDefault ValueDetails
dueOnTypeenumNodata type=string; lov=STATIC
Valid values: interval sqlQuery expression functionBody schedulerExpression
intervalstringYesdata type=string; maxLen=255
Applies whendueOnType = interval
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whendueOnType = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whendueOnType = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = functionBody and language = javaScript-mle
schedulerExpressionmultiline stringYesdata type=multiline string; maxLen=255
Applies whendueOnType = 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
PropertyTypeRequiredDefault ValueDetails
sequencenumberYesdata type=number; maxLen=22
layout {
  sequence: 42
}
parallelFlow
PropertyTypeRequiredDefault ValueDetails
branchreferenceNodata type=reference; lov=COMPONENT; references=branch
parallelFlow {
  branch: @component
}
advanced
PropertyTypeRequiredDefault ValueDetails
staticIdstringYesdata type=string; maxLen=255
labelstringNodata type=string; maxLen=4000
diagramstringNodata type=string; maxLen=32767
advanced {
  staticId: value
  label: value
  diagram: value
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
comments {
  comments: ```
    value
  ```
}

APEXlang Example

activity sample (
    name: value
    type: wait
    timeout {
        timeoutType: static
        sqlQuery: value
        plsqlExpression: value
        plsqlFunctionBody: value
        staticValue: value
        language: plsql
        javascriptExpression: value
        javascriptFunctionBody: 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
        ```
    }
)