topic using a variable in tLDAPInput filter in Talend Studio

using a variable in tLDAPInput filter

quad4x — Sat, 16 Nov 2024 01:24:39 GMT

We are trying to lookup descriptions of Active Directory groups. However, our Active Directory query is limited to 10,000 records so I've broken down my queries to be each letter of the alphabet by iterating through, so that we stay below the limit.

However, I can't seem to get the LDAP input to accept the same Iterate variable that I was able to use in my database query.

DB query:

entitlement like 'CN="+row17.alphabet+"%'

This iterates through the alphabet without issue.

LDAP Filter:

"(&(objectClass=*)(cn="+row17.alphabet+"*))"

This does not compile.

I tried to use (String)globalMap.get("row17.alphabet") as well without success.

Does the filter not accept variables and if so, is there another solution?

Re: using a variable in tLDAPInput filter

Jesperrekuh — Mon, 28 Sep 2020 11:36:04 GMT

You have a screenshot?

It probably has to do with that you put a row... most likely the component works properly if it is triggered/iterated.

Change from row flowToIterate. and use this 'key' var as input.

Re: using a variable in tLDAPInput filter

lennelei — Mon, 28 Sep 2020 12:36:29 GMT

Hi,

The filter should accept "variables".

You can try to look at your job code ("Code" button just below the Job design) and see exactly where your error is.