Resolving a SQLI as bind parameter within another SQLI does not work
Error Message :
N/A
When a SQLI is used as a bind parameter in another SQLI, it returns 0 rows.
Example:
VARA.SEC_SQLI.NESTED_VARA - Notice that column {2} for UC_CLIENT_SETTINGS is 1000003
<Please see attached file for image>
When used as a Bind Parameter, the SQL returns 0 rows.
Use VARA.SEC_SQLI.NESTED_VARA as a parameter in VARA.SEC_SQLI.LIST_STATIC_VARA_VALUES.
{VARA.SEC_SQLI.NESTED_VARA,UC_CLIENT_SETTINGS,2} returns 0 rows when it should be returning 1000003
<Please see attached file for image>
Cause type:
Defect
Root Cause: Nested variables with type SEC_SQLI did not work if variable is used within {} expression as bind-parameters. Preview did not return any result.
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Fix Version(s):
Automation Engine 12.0 - Available
Automation Engine 11.2.3 - Available
Workaround :
Use a regular SQLI instead of SEC_SQLI.