Commands
The list below shows the 30 Query Builder commands curently included in the Gibbon Value Added License.
Admissions
- Remove Orphaned Student Enrolments
Assessment
- Update Internal Assessment Go Live Dates
Attendance
- Delete Absence Data By Student
- Delete Absence Data By Year Group
- Set Target Classes Attendanceable
- Set Target Classes Attendanceable by Year Group
Free Learning
- Delete Open Free Learning Enrolments for Left Students
- Delete Open Free Learning Enrolments in Target Year
- Replace String in Free Learning Unit Course
- Replace String in Free Learning Unit Name
- Set Unit Activation by Course Name
- Switch Free Learning Mentors
Library
- Update Dates for Overdue Library Loans
Planner
- Update Planner Access by Date
- Update Planner Dates by Date
- Update Planner Times By Day - Wednesday
Students & Families
- Clear All Student Transport Details
- Clear Transport and Transport Notes for All Students
- Remove All Student Enrolment by School Year
- Set Parent Email to Yes for all Full Students Enroled in Current Year
- Update Student Start Dates
- Update User Start Dates by Date
Timetable
- Change Timetable Facility by Class
- Change Timetable Space by Person
- Clear Facility by Year Group and Date
- Create Timetable Exceptions for Class Teacher
- Delete All Timetable Days On/After Specified Date
- Delete Facility Changes
- Replace String in Course Name
User Admin
- Set Password by Start Date