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.