Home » Digital Investing World » Defining Service Actions to Replace the Customized Direct Sql Actions in an Active Link - Documentation for Ar System 22.1

Defining Service Actions to Replace the Customized Direct Sql Actions in an Active Link - Documentation for Ar System 22.1

Sophia Al-Mansoor • • 1 min read
Defining Service Actions to Replace the Customized Direct Sql Actions in an Active Link - Documentation for Ar System 22.1

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\\%'
Sophia Al-Mansoor
Author

Sophia Al-Mansoor

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.