Sahana1 (Customer) to rsaSFDCadmin (RSA): asked a question.

formatting the variable value is RSA IGL workflow
I am working on decision node for IGL where I need to evaluate the employee id
which is of a format T123456 and match it with the a different employee ID of
format 123456. Is there a condition in decision node that satisfies my
scenario? Can I use a different node to evaluate of format these values

  • Your SQL node can be something like this



    SELECT
    CASE WHEN (MY CONDITION HERE) THEN 1 Else 0 End as VAR_USER_CHECK
    FROM
    DUAL


    Then you can check the value of _VAR_USER_CHECK _ to traverse further.
    Expand Post
    Selected as Best
  • Your SQL node can be something like this



    SELECT
    CASE WHEN (MY CONDITION HERE) THEN 1 Else 0 End as VAR_USER_CHECK
    FROM
    DUAL


    Then you can check the value of _VAR_USER_CHECK _ to traverse further.
    Expand Post
    Selected as Best