V12.3.0: SQLi-Vara and prep_process_var with Filter does not work

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

On a SEC_SQLI variable, when you define the result format as {1}{2}
in a script object, the prep_process_var with filter does not work.

Steps to reproduce

The SELECT_Mandanten is a SQL - internal varaiable with the following query
SELECT oh.OH_Client FROM oh GROUP BY oh.OH_Client
The result format is {1}{2}

Script 
:set &searchMandant# = format(&$Client#, "00")
:set &var# = prep_process_var(SELECT_Mandanten, '*&searchMandant#*')
:process &var#
:  SET &Mandant# = GET_PROCESS_LINE(&var#, 2)
:  SET &Inhalt# = GET_PROCESS_LINE(&var#, 3)
:  SET &Variablenname# = GET_PROCESS_LINE(&var#, 4)
:  print Trefferzeile <&Mandant#><&Inhalt#><Variablenname#>
:endprocess
:close_process &var#

It should return values only for the logged in client. But it returns for all the clients.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

The issue will be fixed in the following releases.

Status: Fixed:

Automation.Engine 12.3.3 - Available