Little Bug: Staff A-Z

[Andrew Darby]

Hello, just noticed a small bug in the A-Z list of staff. If you have
two or more staff members with the same last name, only one will
display in the A-Z. To fix: Go to
control/includes/classes/sp_StaffDisplay.php, around line 228 and
change this

GROUP BY s.lname

to

ORDER BY s.lname

[Clayton]

We had an opportunity to test this with the arrival of a new staff member.  I applied the fix and can confirm that it does work, but we had to do a little more to make it fully functional.  My colleague, Mike Pullin, "sorted it out."

To get the first names in proper order on the duplicated last name, we changed that same line to:

ORDER BY s.lname, s.fname";

On the Department view, the second staff member with the same last name still did not appear.  So at line 29, we deleted:

group by d.name asc, lname, department_sort desc

It seems to work fine now, but please let me know if you see a problem with removing that line.

- Clayton

[Andrew Darby]

Thanks, Clayton.  Seems to work!

- Clayton

--
You received this message because you are subscribed to the Google Groups "SubjectsPlus" group.
To view this discussion on the web visit https://groups.google.com/d/msg/subjectsplus/-/KQMt5yzBXgkJ.
To post to this group, send email to subjec...@googlegroups.com.
To unsubscribe from this group, send email to subjectsplus...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/subjectsplus?hl=en.