Article Content
Article Number | 000030124 |
Applies To | RSA Product Set: Identity Governance and Lifecycle RSA Product/Service Type: Identity Management and Governance |
Issue | A SQL Select node is a workflow component that allows the user to create custom workflow variables. The user enters a SQL query into the node, and then is able to call the results of the query elsewhere in the workflow.ConfigurationGeneral TabThe general tab of the SQL Select node is the same as the general tab of all nodes. There are fields for the node’s name and description, as well as fields to set various status messages for the node. The values input into the general tab do not affect the resulting variable’s name or contents. Query TabThe query tab contains two fields, the Query field and the Variable Scope Field Query FieldThis is where the select statement is input. If inputting a single statement the query does not need to be terminated by a semicolon. The SQL query has a 4000 character limit, as does the value being retrieved. Variable Scope FieldThe Variable Scope Field determines the scope in which the newly created variable can be called. There are three options: Node level, Job Level, and Public level.
The name of the newly created workflow variable is a composite of the Variable Scope and the Column name/alias that is selected in the query. The scope will be lower cased, the column upper cased, as shown here: ${[scope]UserData_[COLUMN or ALIAS]}
|