SQL Workflow Notification BIC - EnterWorks_Process_Exchange_(EPX) - 10.5

EnterWorks Process Exchange (EPX)

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Precisely EnterWorks
Precisely EnterWorks > EnterWorks
Version
10.5
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks Process Exchange (EPX)
Copyright
2023
First publish date
2007
ft:lastEdition
2024-01-18
ft:lastPublication
2024-01-18T18:45:39.198479

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