You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    How to Parse or Match specific string within a CASE statement

    in Reporting and Analytics for HCM 2 comments

    Summary:

    A Dimension "Job"."job description" returns 'group1.group2.group3.group4'. All four groups are characters of varying length eg 'customer service.customer support.helpdesk.Manager'. How do I only match those that end in '*.*.*.Manager'?

    Content (required):

    NOTE: the above criteria is third logic check in case statement.

    Thanks!

    Mark.

    Version (include the version you are using, if applicable):

    23A

    Code Snippet (add any code snippets that support your topic, if applicable):

    CASE WHEN

    "Job Requisition - Additional Details"."_PMP_" IS NULL  

    AND  

    "Job"."Job Family Name" IN ( 'Operations Support', 'Human Resources', 'Customer Experience')  

    AND  

    "Job"."Job Description" = 'Group1.Group2.Group3.Manager'   

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!