Case-insensitive username search

Question

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

sureshg57 · Answer

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 to use both function usersearch and getuser to achieve case insensitive user search. 
 
 
fn!getusersby(
 recordValue:ri!username,
 recortType:4, /*4=username*/
 operator:1 /*EQUALS=1*/
)
------------------------
fn!usersearch(
 property:{"username"},
 operator : {1}, /*EQUALS=1*/
 value:ri!username
) 
 
 Hope this helps 
 
 Regards 
 Suresh

vijayd · Answer

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.

gajananap · Answer

@ 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

Case-insensitive username search

Top Replies