userSearch Function and LDAP

claudiob over 7 years ago

#LDAP #userSearchI'm importing the manager field from LDAP into a customField1. The value that comes from Active Directory is "CN=Jetson\\, George,OU=Users,OU=Metropolis,DC=SpacelySprockets,DC=local "i can isolate the first name and last name by usign the extract(), substitute() and split() functions. split( substitute( extract(user(ri!user,"customField1"),"CN=",",OU="),"\\",""),",") which results in a list of text string "Jetson; George"Since the value property of userSearch() takes a "list of Text String" I should be able to pass the output of the split function to the userSearch function and get gjetson, the user expected. I can confirm the user exists by trying this piece of code... usersearch({"lastName","firstName"},{1,1}, {"Jetson","George"}) and confirm the user gjetson is returned.however, when I try using the output of split as the value property, it always returns a null. I've tried multiple permutations. loa...

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 7 years ago

@claudiob As far as my observation is considered, there is an additional space being appended to firstName in the LDAP search string which might be the root cause of issue. Please find attached the picture and I believe it might give you leads. Also if you can debug by using the wherecontains() on the output of split() and the actual array of lastName, firstName (i.e., {"Jetson","George"}) you can see that firstName won't appear in search results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 7 years ago

@claudiob As far as my observation is considered, there is an additional space being appended to firstName in the LDAP search string which might be the root cause of issue. Please find attached the picture and I believe it might give you leads. Also if you can debug by using the wherecontains() on the output of split() and the actual array of lastName, firstName (i.e., {"Jetson","George"}) you can see that firstName won't appear in search results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data