parameter - APEXlang Reference

`parameter`

Parent: sourceQuery

Applies when

location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable = false

location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false

location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable = false

Direct Properties:

Property	Type	Required	Default Value	Details
`name`	`reference`	Yes		data type=`reference`; lov=`COMPONENT`; references=`parameter`

Property Groups:

value

Property	Type	Required	Default Value	Details
`type`	`enum`	Yes		data type=`string`; lov=`STATIC` Valid values: `staticValue` `restSourceDefault` `item` `sqlQuery` `expression` `functionBody` `collectionClob` `preference` `null`
`staticValue`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = staticValue and name does not support BOOLEAN_PARAMETER`
`staticValue`	`enum`	Yes		data type=`string`; lov=`STATIC` Valid values: `true` `false` Applies when`type = staticValue and name supports BOOLEAN_PARAMETER`
`sqlQuery`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = sqlQuery`
`item`	`string`	Yes		data type=`string`; maxLen=255; textCase=`UPPER` Applies when`type = item`
`language`	`enum`	Yes	`plsql`	data type=`string`; lov=`STATIC` Valid values: `sql` `plsql` `javaScript-mle` Applies when`type = expression`
`sqlExpression`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = expression and language = sql`
`plsqlExpression`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = expression and language = plsql`
`javaScriptExpression`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = expression and language = javaScript-mle`
`language`	`enum`	Yes	`plsql`	data type=`string`; lov=`STATIC` Valid values: `plsql` `javaScript-mle` Applies when`type = functionBody`
`plsqlFunctionBody`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = functionBody and language = plsql`
`javaScriptFunctionBody`	`multiline string`	Yes		data type=`multiline string`; maxLen=4000 Applies when`type = functionBody and language = javaScript-mle`
`preference`	`string`	Yes		data type=`string`; maxLen=255; textCase=`UPPER` Applies when`type = preference`
`name`	`string`	Yes		data type=`string`; maxLen=255; textCase=`UPPER` Applies when`type = collectionClob`
`formatMask`	`string`	No		data type=`string`; maxLen=255 Applies when`name supports NUMBER_PARAMETER and type in (staticValue)name supports NUMBER_PARAMETER and type in (item)name supports NUMBER_PARAMETER and type in (preference)name supports DATE_PARAMETER and type in (staticValue)name supports DATE_PARAMETER and type in (item)name supports DATE_PARAMETER and type in (preference)name supports TIMESTAMP_PARAMETER and type in (staticValue)name supports TIMESTAMP_PARAMETER and type in (item)name supports TIMESTAMP_PARAMETER and type in (preference)name supports TIMESTAMP_TZ_PARAMETER and type in (staticValue)name supports TIMESTAMP_TZ_PARAMETER and type in (item)name supports TIMESTAMP_TZ_PARAMETER and type in (preference)` Format mask to convert the Static, Item or Preference value to the data type of the REST Source Parameter.
`trueValue`	`string`	No		data type=`string`; maxLen=10 Applies when`name supports BOOLEAN_PARAMETER and type in (item)name supports BOOLEAN_PARAMETER and type in (preference)`
`falseValue`	`string`	No		data type=`string`; maxLen=10 Applies when`name supports BOOLEAN_PARAMETER and type in (item)name supports BOOLEAN_PARAMETER and type in (preference)`

value {
  type: staticValue
  staticValue: ```
    value
  ```
  sqlQuery: ```sql
    value
  ```
  item: value
  language: sql
  sqlExpression: ```sql
    value
  ```
  plsqlExpression: ```plsql
    value
  ```
  javaScriptExpression: ```javascript-mle
    value
  ```
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  preference: value
  name: value
  formatMask: value
  trueValue: value
  falseValue: value
}

APEXlang Example

parameter sample (
    name: @component
    value {
        type: staticValue
        staticValue: ```
          value
        ```
        sqlQuery: ```sql
          value
        ```
        item: value
        language: sql
        sqlExpression: ```sql
          value
        ```
        plsqlExpression: ```plsql
          value
        ```
        javaScriptExpression: ```javascript-mle
          value
        ```
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        preference: value
        name: value
        formatMask: value
        trueValue: value
        falseValue: value
    }
)