I had a closer look at student profiles in Gibbon v17 yesterday and I’m glad about the improvements made since v12.
Anyway, I’m still wondering about one thing. Wouldn’t it be nice get all student profiles? After all, the user can tick “All Students” and list them. I find it a bit strange to be able to do so but then get blocked when clicking “View Details”.
The following simplified query, which doesn’t depend on whether allStudents is on/off works better for me:
$data = array(‘gibbonSchoolYearID’ => $_SESSION[$guid][‘gibbonSchoolYearID’], ‘gibbonPersonID’ => $gibbonPersonID);
$sql = “SELECT * FROM gibbonPerson LEFT JOIN gibbonStudentEnrolment ON (gibbonPerson.gibbonPersonID=gibbonStudentEnrolment.gibbonPersonID AND gibbonSchoolYearID=:gibbonSchoolYearID) WHERE gibbonPerson.gibbonPersonID=:gibbonPersonID”;
What do you think?