taskDefinition

Parent: app

Children: action, parameter, participant

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
namestringYesdata type=string; maxLen=255
Name of this task definition.
typeenumYesdata type=string; lov=STATIC
Valid values: approval action

Property Groups:

  • task
  • deadline
  • source
  • columnMapping
  • advanced
  • comments
task
PropertyTypeRequiredDefault ValueDetails
subjectstringYesdata type=string; maxLen=400
priorityenumYes3data type=string; lov=STATIC
Valid values: 1 2 3 4 5
initiatorCanCompletebooleanYesfalsedata type=boolean
Applies whentype = approval
outcomesstringNodata type=string; maxLen=4000
Applies whentype = action
 
task {
  subject: value
  priority: "1"
  initiatorCanComplete: false
  outcomes: 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
expirationPolicyenumYesnonedata type=string; lov=STATIC
Valid values: none expire renew
Applies whendueOnType is set
maxRenewalCountnumberYesdata type=number; maxLen=22
Applies whendueOnType is set and expirationPolicy = renew
 
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
  ```
  expirationPolicy: none
  maxRenewalCount: 42
}
source
PropertyTypeRequiredDefault ValueDetails
typeenumYesnonedata type=string; lov=STATIC
Valid values: none tableView sqlQuery
tableOwnerstringNodata type=string; maxLen=32767
Applies whentype = tableView
tableNamestringYesdata type=string; maxLen=128
Applies whentype = tableView
sqlQuerymultiline stringYesdata type=multiline string; maxLen=32767
Applies whentype = sqlQuery
A SQL Query returning the system of records Specify the SQL query that will be the source of the data evaluated during the execution of the task associated with this task definition, for example: 
select empno, ename, job, sal
from  emp
Column values can be used within task definition actions with bind variable syntax (for example, :EMPNO). 
source {
  type: none
  tableOwner: value
  tableName: value
  sqlQuery: ```sql
    value
  ```
}
columnMapping
PropertyTypeRequiredDefault ValueDetails
primaryKeyColumnstringNodata type=string; maxLen=32767
Applies whentype = tableView
The primary key column for the table which will serve as the system of records for actions defined for this task definition.
 
columnMapping {
  primaryKeyColumn: value
}
advanced
PropertyTypeRequiredDefault ValueDetails
staticIdstringYesdata type=string; maxLen=255
Static ID for this task definition. The static ID is used when manually executing the automation with the APEX_APPROVAL package (APEX_HUMAN_TASK.CREATE_TASK).
vacationRuleProcedureNamestringNodata type=string; maxLen=500
detailsPagecomplexNodata type=complex; maxLen=32767
 
advanced {
  staticId: value
  vacationRuleProcedureName: value
  detailsPage: {
    type: in_app
    url: value
    app: value
    page: value
    items: [
      value
      value
    ]
    clearCache: value
    action: value
    request: value
    anchor: value
    session: "&SESSION."
    debug: "&DEBUG."
    printerFriendly: N
    otherArgs: value
  }
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
 
comments {
  comments: ```
    value
  ```
}

APEXlang Example

taskDefinition sample (
    name: value
    type: approval
    task {
        subject: value
        priority: "1"
        initiatorCanComplete: false
        outcomes: 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
        ```
        expirationPolicy: none
        maxRenewalCount: 42
    }
    source {
        type: none
        tableOwner: value
        tableName: value
        sqlQuery: ```sql
          value
        ```
    }
    columnMapping {
        primaryKeyColumn: value
    }
    advanced {
        staticId: value
        vacationRuleProcedureName: value
        detailsPage: {
          type: in_app
          url: value
          app: value
          page: value
          items: [
            value
            value
          ]
          clearCache: value
          action: value
          request: value
          anchor: value
          session: "&SESSION."
          debug: "&DEBUG."
          printerFriendly: N
          otherArgs: value
        }
    }
    comments {
        comments: ```
          value
        ```
    }
)