How to use a custom select in an eligibility profile for learner group?
Hello,
I want to create an eligibility profile, that will be used for a Learning Management learner group. To determine a person's eligibility, I want to put the following two selects into a function, add them up, and if the function returns a value > 0, include the person, otherwise exclude the person.
The selects determine if an employee actually supervises another, or is a timecard approver for another.
select count (1)
from per_assignments_f where supervisor_id = <person_id being evaluated>
and sysdate between effective_start_date and effective_end_date
and primary_flag = 'Y' and assignment_type = 'E'
select count (1)