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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Hi i need some help with requisition query

Summary:


Content (please ensure you mask any confidential information):

actually, all these 4 records are for same person so is there any way to restrict the data only to pull based on latest creation date, i have attached the query for reference, we are pulling records :

Phase = “New”

  • State = Manager Review (pull only the candidates who were in/are currently in this state).  

 

Phase = “Screen”

  • Pull all candidates who were in/are currently in the “screen” phase, regardless of “state”

 

Phase = “Interview & Selection”

  • Pull all candidates who were in/are currently in the “interview & selection” phase, regardless of “state”

 

Phase = “Offer”

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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