Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I got it working.
-AU
May i know please among the above transformations, which one have you used.
Thanks.