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

EnterWorks Process Exchange (EPX)

Product type
Product family
Precisely EnterWorks > EnterWorks
Precisely EnterWorks
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Product name
Precisely EnterWorks
EnterWorks Process Exchange (EPX)
First publish date

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.


  • 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)


  • 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.