Customize Search Filter for LDAP Picker Field

[Jh]

I am trying to create a LDAP picker custom field to show user's departments. I get it to work but the results are showing non-distinct results and so there are many duplicates. Is there a way I can just filter the results so they do not show duplicates?

My current LDAP query is:

(&(objectCategory=person)(objectClass=user)(department=*))

 Search attribute and display attribute are both: department

When I use the preview, the results are showing essentially duplicate departments, which I believe the reason is the query is looking for all users and then displaying their departments.

[mogavenasan]

Hi @Jh,

As explained in stackoverflow, there is no way to ask AD for a deduplicated list of department values. Your LDAP filter is the closest we can do and then we will need to deduplicate it after retrieving the results.

I believe you are using the Scriptrunner LDAP Picker field, if yes, then there is some customization that can be done. Perhaps, you can have a script to deduplicate the result from the LDAP filter.

I hope that this helps.

Thanks,
Moga