SQL Set Properties 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

Sets properties in a work item based on the results (first row only) of a query.

Inputs

  • databaseName – identifies the database to be queried: EPIM (default) or EPX
  • sql_query - Defines the SQL query to execute against the Enable database. Work item properties can be referenced by surrounding them 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.
  • inOutNameX - Name of the work item property to be updated with the corresponding in/out value.
  • inOutValueX - Value to store in the corresponding in/out property. Result columns can be referenced by surrounding the column name with double-pipe characters.

Outputs

  • sql_num_rows - Number of rows returned by the SQL query
  • set_property_status - Indicates whether set property operation was successful (SUCCESS) or failed (FAIL).
  • set_property_message - Reason for failure.