SQL Create Saved Set 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 saved set based on the InternalRecordIds returned from the designated SQL query.

Inputs

  • sql_query - Defines the SQL query to execute against the Enable database that returns a single column - the InternalRecordId of each record to be added to the saved set. 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.
  • repositoryName - Name of the repository in which the Saved Set is to be defined. The InternalRecordId values must reside in this repository.
  • savedSetName - Name of the saved set to be created. This needs to be unique or already defined in the designated repository. If the saved set name is defined in a different repository, this operation will fail with an error.
  • deleteSavedSet - Delete the saved set if it already exists if Yes. If no, the records found will be added to the existing saved set.
  • createTemporarySavedSet - Flags the saved set as temporary (which means it won't be visible in the UI) if YES.

Outputs

  • isCreated – The saved set was successfully created if true;
  • errorMsg - Details for failure if saved set was not created
  • sql_num_rows - Number of rows returned by the SQL query
  • savedSetId – ID of the saved set.