Get Started with Redwood for Oracle Cloud HCM Begin Now
Is it possible to use a self join condition?
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
0