Filter a value in the target lookup

Attunity_user — Fri, 15 Nov 2024 23:04:29 GMT

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,

Re: Filter a value in the target lookup

Attunity_user — Sun, 14 Mar 2021 02:43:51 GMT

I got it working.

-AU

suvbin — Mon, 10 Apr 2023 06:53:23 GMT

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

Thanks.