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
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

    SQL similar to OR Statement

    edited Dec 13, 2022 7:08AM in Taleo Enterprise 6 comments

    Summary

    How to filter more than one column in an analysis

    Content

    Hi Experts,

    Could you please advise how to filter more than one column based on multiple attributes? I am trying to assign "Y" value to a UDF field as long as one of the following four conditions matches. 

    1. "Candidate Regulations"."Recently Separated Veteran" in ('Separate Veteran – Yes') then 'Y'

    2. "Candidate Regulations"."Special Disabled Veteran" in ('Special disabled Veteran - Yes') then 'Y'

    3. "Candidate Regulations"."Other Protected Veteran" in ('Protected Veteran – Yes') then 'Y' 

    4. "Candidate Regulations"."Disabled Veteran" in ('Disabled Veteran - Yes') then 'Y' 

    Here is what my formula looks like:

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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