• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 12 replies
  • Answers 3 answers
  • Subscribers 7 subscribers
  • Views 13296 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

Case-insensitive username search

Kyle Jorgensen
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

Parents
  • 0
    Hi Kyle, given that all your users are known to be in all lower case, you can create a custom rule, call it something like myUser() or abcUser(). The rule only need to be as simple as:

    user(lower(ri!username), ri!property)

    Then let all developers/designers know to use this new rule instead of user(). If you name the rule specific enough for your organization, then you can just call it directly such as abcUser() and not rule!abcUser() without worrying that the name will clash with something else later.
Reply
  • 0
    Hi Kyle, given that all your users are known to be in all lower case, you can create a custom rule, call it something like myUser() or abcUser(). The rule only need to be as simple as:

    user(lower(ri!username), ri!property)

    Then let all developers/designers know to use this new rule instead of user(). If you name the rule specific enough for your organization, then you can just call it directly such as abcUser() and not rule!abcUser() without worrying that the name will clash with something else later.
Children
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.