IntraApps: Faculty – Display Chair department description on Chair pages

Custom existing shortcode and provide parameter to set language For English age: [pap_faculty_chairs language=”en“] For Chinese age: [pap_faculty_chairs language=”zh“] Retrieve and display on Faculty who are the Chair of a department: Selection criteria: display = “Y” ischair = 1 language LIKE ‘%en%’ or ‘%zh%’ Sorting: English page: sort by English Last name, First name ASC … Read more

Clinic Faculty records housekeeping

There are some relations between Faculty and Clinic Faculty tables For any record in the Clinic Faculty table, it should have a mapped Faculty ID exists in the Faculty table. There are First name and Last name fields in the Clinic Faculty table. But to simplify record maintenance purpose, they will not be used. Instead, … Read more