Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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.
How to filter the employees basing on their Grade in a BIP Report
Summary:
How to filter the employees basing on their Grade in a BIP Report
Content (please ensure you mask any confidential information):
Hi,
we created a BI Report. Among the pieces of information included in our report, we entered the Grade. We would like to exclude, from the results, the pieces of information related to the employees who have some specific values associated with their grade. In order to do that, we used this sql query:
SELECT
….
FROM per_assignment_secured_list_v asg
LEFT JOIN PER_GRADES_F_VL GRADE ON GRADE.GRADE_ID=ASG.GRADE_ID
WHERE GRADE.NAME NOT IN ('24','25')
Tagged:
0