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

Multiple Query BO report with Historical Tracking- Help to convert to OBI

edited Dec 13, 2022 7:01AM in Taleo Enterprise 3 comments

Summary

We have a number of reports which use the concept of a main query and then other queries to isolate status events from tracking history. I cannot seem to replicate this result in OBI.

Content

Requirement- Report filters on candidates who had an interviewed scheduled (based on step/status history) in the previous 7 days.

Then displays scheduled date (from above query) and other workflow dates based on separate queries. (e.g. to be scheduled date, user who moved the candidate to the to be scheduled date).

In OBI, if I filter on the main query of those scheduled in the previous 7 days, then I cannot apply case statements to get the other dates because I've filtered out the results already.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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