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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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