Filter a value in the target lookup

[Attunity_user]

Hello,

Please advise the syntax for the target/source lookup if need to filter for a value.

DEPARTMENT_NAME=='ABC'

target_lookup(10000,'HR','DEPARTMENTS','DEPARTMENT_NAME',

'DEPARTMENT_ID=:1',$DEPARTMENT_ID)

Below examples did not work:

target_lookup(10000,'HR','DEPARTMENTS','DEPARTMENT_NAME =”ABC”',

'DEPARTMENT_ID=:1',$DEPARTMENT_ID)

target_lookup(10000,'HR','DEPARTMENTS','DEPARTMENT_NAME',

'DEPARTMENT_ID=:1',$DEPARTMENT_ID)=="ABC"

target_lookup((10000,'HR','DEPARTMENTS','DEPARTMENT_NAME',

'DEPARTMENT_ID=:1',$DEPARTMENT_ID)="ABC")

target_lookup(10000,'HR','DEPARTMENTS','DEPARTMENT_NAME =”ABC”',

'DEPARTMENT_ID=:1',$DEPARTMENT_ID)

Thanks,

AU

[Attunity_user · Accepted solution]

I got it working.

-AU

[suvbin]

Hi @Attunity_user 

May i know please among the above transformations, which one have you used.

Thanks.