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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need help with SQL query (OBIEE Dataset)
Summary
Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content
Hi All,
I am trying to build a report to show data for an employee on 2 different dates (ie: Data from Jan 1, 2020 and data from Jun 30, 2020)
some fields to be shown are:
location, department, people group, comp group, shift schedule, etc.
I think I have the query to pull the data for the 2 different dates but now I need to only pick up those records where any of the fields have changed
If no change has happened between the 2 dates, then I don't want to show the employee on the report.
0