Executes a SQL query and generates a work item for each result row on the Notify workflow to generate a notification work item event.
Inputs
- sql_query - Defines the SQL query to execute against the Enable database. Each of the properties below can reference SQL column results by surrounding the column names 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.
- notifyRecipient - Group or login name of the recipient for the notification
- repositoryName - Name of the repository containing the record represented by the work item.
- repositoryId - ID of the repository containing the record represented by the work item
- workItemId - ID of the work item for which the notification is to be generated
- taskName - Work Item Task (e.g. Notify)
- taskRole - Value of a work item property taskRole to be set
- taskDescription - Value of a work item property taskDescription to be set
- taskStatus - Value of a work item property taskStatus to be set
- workflowCommentHistory - Value of a work item property workflowCommentHistory to be set
- workItemCreationDate - Value of a work item property workItemCreationDate to be set
- batchSize - Number of records to process before delaying. A value of zero (or blank) means no batch delay will be applied.
- batchDelayMinutes - Number of minutes to delay processing after each batch has been processed.
Outputs
- sql_num_rows - Number of rows returned by the SQL query
- notifySentCount - Number of notices sent
- notifySent - All notify work items were successfully created if true
- errorMsg - Details for failure if notify work item was not created