process (legacyAutoRowProcessing)

Parent: process

Applies whentype = legacyAutoRowProcessing

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
namestringYesdata type=string; maxLen=255
Enter the name of the process for easy identification by developers.
typeenumYesdata type=string; lov=PLUGINS
Valid values: legacyAutoRowProcessing
executionChainreferenceNodata type=reference; lov=COMPONENT; references=process
formRegionreferenceYesdata type=reference; lov=COMPONENT; references=region
editableRegionreferenceNodata type=reference; lov=COMPONENT; references=region
Applies whenexecutionChain does not support RUN_IN_BACKGROUND

Property Groups:

  • target
  • genAI
  • source
  • execution
  • successMessage
  • error
  • advanced
  • serverSideCondition
  • security
  • config
  • comments
target
PropertyTypeRequiredDefault ValueDetails
typeenumYesinsertdata type=string; maxLen=4000; lov=STATIC
Valid values: update insert delete
tableOwnerstringNodata type=string; maxLen=128
tableNamestringYesdata type=string; maxLen=128
pkItemstringYesdata type=string; maxLen=4000; textCase=UPPER
pkColumnstringYesdata type=string; maxLen=128
runtimeWhereClausestringNodata type=string; maxLen=4000
target {
  type: update
  tableOwner: value
  tableName: value
  pkItem: value
  pkColumn: value
  runtimeWhereClause: 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
}
execution
PropertyTypeRequiredDefault ValueDetails
sequencenumberYesdata type=number; maxLen=22
pointenumYesprocessingdata type=string; lov=STATIC
Valid values: newSession beforeHeader afterHeader beforeRegions afterRegions beforeFooter afterFooter afterSubmit processing ajaxCallback
runProcessenumYesoncePerPageVisitDefaultdata type=string; lov=STATIC
Valid values: oncePerSessionOrWhenReset oncePerPageVisitDefault
execution {
  sequence: 42
  point: newSession
  runProcess: oncePerSessionOrWhenReset
}
successMessage
PropertyTypeRequiredDefault ValueDetails
successMessagemultiline stringNodata type=multiline string; maxLen=4000

Enter the success message for this process. If the process runs and does not generate an error, then this process success message displays in the notification section of the resulting page displayed. If you are branching to another page via a URL redirect, you may need to check the preserve success message attribute.

For multi row processes, the following substitution string can be used to get the number of records processed:

  • Insert: #MRI_COUNT#
  • Update: #MRU_COUNT#
  • Delete: #MRD_COUNT#

For the Send E-Mail process type the substitution string #TO# can be used to get the addressees of the e-mail.

Plug-ins can have other substitution strings as well. See Plug-in documentation for details.

successMessage {
  successMessage: ```
    value
  ```
}
error
PropertyTypeRequiredDefault ValueDetails
errorMessagemultiline stringNodata type=multiline string; maxLen=4000

Enter the error message for this process. This message displays if an unhandled exception is raised. After any error processing stops, a rollback is issued and an error message displays.

Note: the SQL error message sqlerrm displays by default if On Error Page is defined as the error display location, there is no need to add #SQLERRM# to your error text.

Error messages can include the following substitution strings:

#SQLERRM_TEXT#
Text of error message without the error number.
#SQLERRM#
Complete error message.
displayLocationenumYesinlineInNotificationdata type=string; lov=STATIC
Valid values: inlineInNotification onErrorPage
Applies whenpoint in (afterSubmit)point in (processing)
error {
  errorMessage: ```
    value
  ```
  displayLocation: inlineInNotification
}
advanced
PropertyTypeRequiredDefault ValueDetails
staticIdstringYesdata type=string; maxLen=255
executionMappingIdentifierstringNodata type=string; maxLen=32767
advanced {
  staticId: value
  executionMappingIdentifier: value
}
serverSideCondition
PropertyTypeRequiredDefault ValueDetails
whenButtonPressedreferenceNodata type=reference; lov=COMPONENT; references=button
executionScopeenumYesforCreatedAndModifiedRowsdata type=string; lov=STATIC
Valid values: forCreatedAndModifiedRows allSubmittedRows
Applies whenexecutionChain does not support RUN_IN_BACKGROUND and editableRegion is set
typeenumNodata type=string; lov=STATIC
Valid values: always rowsReturned noRowsReturned expression functionBody request=Value request!=Value requestIsContainedInValue requestIsNotContainedInValue item=value item!=value itemIsNull itemIsNotNull itemIsZero itemIsNotZero itemIsNullOrZero itemIsNotNullAndNotZero itemContainsNoSpaces itemIsNumeric itemIsNotNumeric itemIsAlphanumeric itemIsInColonDelimitedList itemIsNotInColonDelimitedList textIsContainedInItem text=value text!=value textIsContainedInValue textIsNotContainedInValue userPreference=value userPreference!=value currentPage=page currentPage!=page currentPageInList currentPageNotInList currentPage=pageSubmitted currentPage!=pageSubmitted currentPageIsInPrinterFriendlyMode currentPageIsNotInPrinterFriendlyMode pageRegionIsReadOnly pageRegionIsNotReadOnly userIsAuthenticated userIsPublicUser inlineValidationErrorsDisplayed inlineValidationErrorsNotDisplayed sqlReportsOkToShowForwardButton sqlReportsOkToShowBackButton currentLanguage=value currentLanguage!=value currentLanguageIsContainedInValue currentLanguageIsNotContainedInValue clientBrowserIsMozilla clientBrowserIsIE7higher clientBrowserIsXhtmlCssCapable clientBrowserIsOther cgiEnvDadName=value cgiEnvDadName!=value cgiEnvServerName=value cgiEnvServerName!=value cgiEnvHttpHost=value cgiEnvHttpHost!=value never
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype in (rowsReturned)type in (noRowsReturned)
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whentype = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = javaScript-mle
valuestringYesdata type=string; maxLen=4000
Applies whentype in (request=Value)type in (request!=Value)type in (requestIsContainedInValue)type in (requestIsNotContainedInValue)type in (currentLanguageIsContainedInValue)type in (currentLanguageIsNotContainedInValue)type in (currentLanguage!=value)type in (currentLanguage=value)type in (cgiEnvDadName=value)type in (cgiEnvDadName!=value)type in (cgiEnvServerName=value)type in (cgiEnvServerName!=value)type in (cgiEnvHttpHost=value)type in (cgiEnvHttpHost!=value)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype in (item=value)type in (item!=value)type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type in (itemIsNull)type in (itemIsNotNull)type in (itemIsZero)type in (itemIsNotZero)type in (itemIsNullOrZero)type in (itemIsNotNullAndNotZero)type in (itemContainsNoSpaces)type in (itemIsNumeric)type in (itemIsNotNumeric)type in (itemIsAlphanumeric)type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList)
preferencestringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype in (userPreference=value)type in (userPreference!=value)
pageintegerYesdata type=integer; maxLen=4000
Applies whentype in (currentPage=page)type in (currentPage!=page)
pagesarray of integersYesdata type=integer; maxLen=4000
Applies whentype in (currentPageInList)type in (currentPageNotInList)
textstringYesdata type=string; maxLen=4000
Applies whentype in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value)
valuestringYesdata type=string; maxLen=4000
Applies whentype in (item=value)type in (item!=value)type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)
listarray of stringsYesdata type=string; maxLen=4000
Applies whentype in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList)
itemstringYesdata type=string; maxLen=4000; textCase=UPPER
Applies whentype = textIsContainedInItem
valuestringYesdata type=string; maxLen=4000
Applies whentype in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value)
executeConditionenumYesforEachRowdata type=string; lov=STATIC
Valid values: forEachRow once
Applies whenexecutionChain does not support RUN_IN_BACKGROUND and editableRegion is set and type is set
serverSideCondition {
  whenButtonPressed: @component
  executionScope: forCreatedAndModifiedRows
  type: always
  sqlQuery: ```sql
    value
  ```
  language: sql
  sqlExpression: ```sql
    value
  ```
  plsqlExpression: ```plsql
    value
  ```
  javaScriptExpression: ```javascript-mle
    value
  ```
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  value: value
  item: value
  preference: value
  page: 42
  pages: [
    42
    42
  ]
  text: value
  list: [
    value
    value
  ]
  executeCondition: forEachRow
}
security
PropertyTypeRequiredDefault ValueDetails
authorizationSchemeenumNodata type=reference; lov=COMPONENT; references=authorization
Valid values: mustNotBePublicUser
security {
  authorizationScheme: mustNotBePublicUser
}
config
PropertyTypeRequiredDefault ValueDetails
buildOptionreferenceNodata type=reference; lov=COMPONENT; references=buildOption
config {
  buildOption: @component
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
comments {
  comments: ```
    value
  ```
}

APEXlang Example

process sample (
    name: value
    type: legacyAutoRowProcessing
    executionChain: @component
    formRegion: @component
    editableRegion: @component
    target {
        type: update
        tableOwner: value
        tableName: value
        pkItem: value
        pkColumn: value
        runtimeWhereClause: value
    }
    genAI {
        enabled: false
        agent: @component
        service: @component
        systemPrompt: ```
          value
        ```
    }
    source {
        location: localDatabase
        language: plsql
        plsqlCode: ```plsql
          value
        ```
        javaScriptCode: ```javascript-mle
          value
        ```
        remoteServer: @component
    }
    execution {
        sequence: 42
        point: newSession
        runProcess: oncePerSessionOrWhenReset
    }
    successMessage {
        successMessage: ```
          value
        ```
    }
    error {
        errorMessage: ```
          value
        ```
        displayLocation: inlineInNotification
    }
    advanced {
        staticId: value
        executionMappingIdentifier: value
    }
    serverSideCondition {
        whenButtonPressed: @component
        executionScope: forCreatedAndModifiedRows
        type: always
        sqlQuery: ```sql
          value
        ```
        language: sql
        sqlExpression: ```sql
          value
        ```
        plsqlExpression: ```plsql
          value
        ```
        javaScriptExpression: ```javascript-mle
          value
        ```
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        value: value
        item: value
        preference: value
        page: 42
        pages: [
          42
          42
        ]
        text: value
        list: [
          value
          value
        ]
        executeCondition: forEachRow
    }
    security {
        authorizationScheme: mustNotBePublicUser
    }
    config {
        buildOption: @component
    }
    comments {
        comments: ```
          value
        ```
    }
)