using a variable in tLDAPInput filter

[quad4x]

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?

[Jesperrekuh]

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.

[lennelei]

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.