StudentFinder control enhancements

[Brian Lewis]

Provide some search constraints as bindings on this control: specifically year and schoolNo.

e.g.

<student-finder year=”2022” schoolNo=”CHK203” ng-model=”vm.student”/>

So the year and schoolNo can be dynamically set, allowing a dynamic context driven search of students. This is motivated by trying to better support Jasper Input Dialogs

[Brian Lewis]

Various enhancements added to ExamCAndidateFinder in #1387. These can be ported to the other Finders.

Notably: some more resilient handling of when to / when not to/ refresh the list

formatting of the list items, to highlight search text, and constraints

Jasper Reports Parameters Dialog to supply and onSelected event to update any related controls from the student data.

‌

Similarly for TeacherFinder.

[Brian Lewis]

task(sql): Sql changes for StudentFinder and CandidateFinder

Resolves #1386, #1387

→ <<cset 69b4c22da7f3>>