Additional Context Data
Description
Specifies how to determine a read-only context data value using an SQL query.
The query may use ${xxx} variables to refer to database columns in the main object (e.g. user) the context data is added to.
Example (reading a user): SELECT separateColum FROM OTHER_TABLE WHERE username = ${username}
From the result of the query, the first selected column is interpreted as string and used as context data value.
May be used by
Properties
Name (
name) Description
The name of the context data field.
Attributes
String
Mandatory
Example
customField1
Query (
query) Description
The SQL query used to retrieve the value for the context data field. See plugin description for details.
Attributes
String
Mandatory
Example
SELECT separateColum FROM OTHER_TABLE WHERE username = ${username}
YAML Template (with default values)
type: AdditionalContextData
id: AdditionalContextData-xxxxxx
displayName:
comment:
properties:
name:
query: