...
| Code Block |
|---|
select system_role.id as system_role_id, person.id as person_id, name, username, role_id, role, system_role.office_id, campus.description from person, system_role, role, campus, office where person.id=system_role.person_id and role.id=system_role.role_id and office.id=system_role.office_id and campus.id=office.campus_id order by person_id; |
Applications with a negative recommendation at any level (just need to replace the year)
| Code Block |
|---|
select application.id, campus.description, office.description from application, office, campus where
application.office_id=office.id and
office.campus_id=campus.id and
year=2019 and application.id in (select distinct application_id from
application_recommendation where recommendation='N' or recommendation2='N'); |