Sets properties in a work item based on the results (first row only) of a query.
Inputs
- databaseName – identifies the database to be queried: EPIM (default) or EPX
- sql_query - Defines the SQL query to execute against the Enable database. Work item properties can be referenced by surrounding them with double-pipe characters. NOTE: Percent signs are used to denote a work item property reference. To use percent signs in the actual SQL query (e.g., wildcard in LIKE statement), precede each with a backslash character. For example: WHERE myColumn LIKE '\%something\%'. If referencing a work item property and the value may contain single quotes, surround the property reference with curly braces to ensure any single quotes are escaped. For example: WHERE myColumn LIKE '{%myProperty%}'. The curly braces must be inside the single quotes AND the property value cannot have any curly braces itself.
- inOutNameX - Name of the work item property to be updated with the corresponding in/out value.
- inOutValueX - Value to store in the corresponding in/out property. Result columns can be referenced by surrounding the column name with double-pipe characters.
Outputs
- sql_num_rows - Number of rows returned by the SQL query
- set_property_status - Indicates whether set property operation was successful (SUCCESS) or failed (FAIL).
- set_property_message - Reason for failure.