While adding a new Faculty from the IntraNet Faculty UI,Faculty – Add a new Faculty“SQL error” was encountered. After looking into the SQL that caused the issue, it was found that a new data field “type” was missing from the original “insert” SQL statement. Because that data field was introduced after the original SQL statement. … Read more
They “type” database field was added while setting up two new Faculty groups:“Honorable” and “Former” Faculty All existing facutly are considered “Active” faculty. To prevent “Honorable” and “Former” Faculty being retrieved as Active faculty, the existing Faculty group retrieval SQLs should include “type” as part of searching criteria. Update the following Faculty lists to include … Read more