Case-insensitive username search

The issue is that some users are all lowercase, while others are mixed (e.g. given the usernames JDoe, doeja, KimDa, lawre I have no way of matching them to a list like this from a source system {"jdoe", "doeja", "kimda", "lawre"}. I think the application that was having this problem is going to see if the source system can pass user emails to Appian, rather than usernames since those can be matched easily.

The issue is that some users are all lowercase, while others are mixed (e.g. given the usernames JDoe, doeja, KimDa, lawre I have no way of matching them to a list like this from a source system {"jdoe", "doeja", "kimda", "lawre"}. I think the application that was having this problem is going to see if the source system can pass user emails to Appian, rather than usernames since those can be matched easily.

During LDAP sync, the user name can be copied over to one of the Appian user custom field and then you can call usersearch function to get exact username. for example
usersearch ({“customFiled1”} ,{0} , {“username from source application”})[0] will return Appian username

Hope this helps

Agree with Christine , Appian usernames are case sensitive. If there is a standard format for the usernames in terms of cases then writing a custom rule to achieve the target usernames would solve this problem.

@vijayd , the above solution provided by me will solve case sensitive user name search. only problem with this solution is you have to copy a username to a custom field