Defining Service actions to replace the customized Direct SQL actions in an active link - Documentation for AR System 22.1

Before you begin

Use the SQL query to obtain the list of active links that include Direct SQL actions. Before running the query, ensure that you have access to the  BMC Helix Innovation Suite database.

For example, a database administrator runs the following query on the database to obtain a list of Direct SQL action active links:

select al.resolvedname, al.overlayprop, als.fieldid, als.assignshort from actlink al, actlink_set als where al.actlinkid = als.actlinkid and als.assignShort like '107\\%'