In the current design, a Course can be assigned to multiple departments. So the data field “departmentids” should be used for record selection, not “departmentid” field.
By the same token, if a Degree ID is to be matched, the data field “degreeids” should be used, not “degreeid” field.
Update the data field used in SQLs, replacing “departmentid” with “departmentids” when searching if the provided Department ID exists in the “departmentids” field. Same goes to Degree ID, check if it existis in “degreeids” field, not “degreeid”.
1 thought on “Update Course related Shortcode”
Closed