Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
12 replies
Answers
3 answers
Subscribers
8 subscribers
Views
14471 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Case-insensitive username search
Kyle Jorgensen
over 8 years ago
A list of usernames is coming into the system via an external source in an all-lowercase format. Is there a way to do a case insensitive username search in Appian? user() is case sensitive and usersearch() does not appear to have username as a search option.
OriginalPostID-251460
Discussion posts and replies are publicly visible
Top Replies
sureshg57
over 7 years ago
+2
suggested
Hi Kyle Jorgensen I think the usersearch function will work and I have tried this my own. check what version you are using for the plugin. I use Get Users By (Expression) (v2.2.3) . I was able…
Parents
0
Kyle Jorgensen
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
gajananap
over 7 years ago
in reply to
Kyle Jorgensen
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
gajananap
over 7 years ago
in reply to
Kyle Jorgensen
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
+1
vijayd
over 7 years ago
in reply to
gajananap
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
+1
gajananap
over 7 years ago
in reply to
vijayd
@
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel