<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
0D51Y00006kf5jgSAAOkta Classic EngineAdministrationAnswered2024-04-15T12:54:23.000Z2019-10-10T16:00:33.000Z2019-10-23T22:19:35.000Z
  • Hi Anil Thomas,

     

    There is indeed an expression you can use using NOT logic. Unfortunately this expression is rather obnoxious, but the following will exclude anyone with an employeeNumber that includes a letter and/or is blank:

     

    !(String.stringContains(user.employeeNumber,"A") or String.stringContains(user.employeeNumber,"B") or String.stringContains(user.employeeNumber,"C") or String.stringContains(user.employeeNumber,"D") or String.stringContains(user.employeeNumber,"E") or String.stringContains(user.employeeNumber,"F") or String.stringContains(user.employeeNumber,"G") or String.stringContains(user.employeeNumber,"H") or String.stringContains(user.employeeNumber,"I") or String.stringContains(user.employeeNumber,"J") or String.stringContains(user.employeeNumber,"K") or String.stringContains(user.employeeNumber,"L") or String.stringContains(user.employeeNumber,"M") or String.stringContains(user.employeeNumber,"N") or String.stringContains(user.employeeNumber,"O") or String.stringContains(user.employeeNumber,"P") or String.stringContains(user.employeeNumber,"Q") or String.stringContains(user.employeeNumber,"R") or String.stringContains(user.employeeNumber,"S") or String.stringContains(user.employeeNumber,"T")  or String.stringContains(user.employeeNumber,"U") or String.stringContains(user.employeeNumber,"V") or String.stringContains(user.employeeNumber,"W") or String.stringContains(user.employeeNumber,"X") or String.stringContains(user.employeeNumber,"Y") or String.stringContains(user.employeeNumber,"Z")) and String.len(user.employeeNumber) != 0

     

    Note that you'd want to replace user.employeeNumber with whatever your attribute's variable name is.

     

    Thanks,

     

    Brian Anderson

    KCS Specialist

    Okta

    Expand Post
    Selected as Best
  • Hi Anil Thomas,

     

    There is indeed an expression you can use using NOT logic. Unfortunately this expression is rather obnoxious, but the following will exclude anyone with an employeeNumber that includes a letter and/or is blank:

     

    !(String.stringContains(user.employeeNumber,"A") or String.stringContains(user.employeeNumber,"B") or String.stringContains(user.employeeNumber,"C") or String.stringContains(user.employeeNumber,"D") or String.stringContains(user.employeeNumber,"E") or String.stringContains(user.employeeNumber,"F") or String.stringContains(user.employeeNumber,"G") or String.stringContains(user.employeeNumber,"H") or String.stringContains(user.employeeNumber,"I") or String.stringContains(user.employeeNumber,"J") or String.stringContains(user.employeeNumber,"K") or String.stringContains(user.employeeNumber,"L") or String.stringContains(user.employeeNumber,"M") or String.stringContains(user.employeeNumber,"N") or String.stringContains(user.employeeNumber,"O") or String.stringContains(user.employeeNumber,"P") or String.stringContains(user.employeeNumber,"Q") or String.stringContains(user.employeeNumber,"R") or String.stringContains(user.employeeNumber,"S") or String.stringContains(user.employeeNumber,"T")  or String.stringContains(user.employeeNumber,"U") or String.stringContains(user.employeeNumber,"V") or String.stringContains(user.employeeNumber,"W") or String.stringContains(user.employeeNumber,"X") or String.stringContains(user.employeeNumber,"Y") or String.stringContains(user.employeeNumber,"Z")) and String.len(user.employeeNumber) != 0

     

    Note that you'd want to replace user.employeeNumber with whatever your attribute's variable name is.

     

    Thanks,

     

    Brian Anderson

    KCS Specialist

    Okta

    Expand Post
    Selected as Best
This question is closed.
Loading
Expression language - check user string attribute is numeric?