Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Is it possible to use a self join condition? — Cloud Customer Connect
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

Is it possible to use a self join condition?

Received Response
27
Views
1
Comments
edited Apr 8, 2019 12:59PM in Reporting and Analytics Taleo Enterprise 1 comment

Summary

Is it possible to use a self join condition?

Content

Hi All,

           Is it possible to have a Self Join condition while creating an analysis?. Ex – I have a report with three columns – Req Id,Req Creation Date and Previous Req Id value. This Previous Req Id value is a UDF that will hold the value of another related (old) req id. Now, I need to add a fourth column to the report, that will take the Previous Req ID value and return the Creation date of that Req. Basically, I need to join the Previous Req Id value in the “Recruiting “ subject area with the “Requisition Identifier” field

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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