SQL Create Work Item BIC - EnterWorks_Process_Exchange_(EPX) - 10.5

EnterWorks Process Exchange (EPX)

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > EnterWorks
Precisely EnterWorks
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Version
10.5
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks Process Exchange (EPX)
Copyright
2023
First publish date
2007

Creates a work item on a workflow at the designated starting point activity with the specified work item properties for each row returned in the designated SQL query. If the query returns 0 rows, then no work items will be generated.

Inputs

  • sql_query - Defines the SQL query to execute against the Enable database. Work item properties can be referenced by surrounding them with percent signs. NOTE: 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.
  • userName - Login of the user for which to create the work item. Blank means to use the default defined in Enterworks.properties
  • workflowName - Name of the main workflow in which the work item resides
  • activityName - Name of the activity in which the work item should be found
  • workItemName - Optional name for the work item
  • workItemDescription - Optional description for the work item
  • batchSize - Number of records to process before delaying. A value of zero (or blank) means no batch dely will be applied.
  • batchDelayMinutes - Number of minutes to delay processing after each batch has been processed
  • copyProperties - Copy all work item properties from the current work item to the new work item if YES. These properties may be overwritten by the subsequent properties listed below
  • wipNameX - Name of a work item property to be set (* in first property = copy all properties
  • wipValueX - Value of a work item property to be set (* in first property = copy all properties)

Outputs

  • isCreated - Work items were successfully created if true");
  • errorMsg - Details for failure if work item was not advanced
  • sql_num_rows - Number of rows returned by the SQL query
  • workItemSendCount - Number of work items sent successfully.
  • workItemFailCount - Number of work items that failed to be sent.