Hello, I’m Mercedes from Human Study.
We are considering implementing Gibbon for staff management, and I am testing on local environment the platform.
I have been looking for a way to filter staff when searching by different data, like subjects if they are teachers, skills or spoken languages. Does anyone know if this is possible?
Hello @Merce,
I believe that to do advanced research on your staff you should use the optional Query Builder module.
With this module you have the ability to create and execute SQL queries to visualize database data with your custom criteria.
Example :
select gibbonPerson.officialName, gibbonPerson.gibbonRoleIDPrimary, gibbonRole.description, gibbonPerson.languageFirst, gibbonPerson.languageSecond, gibbonPerson.languageThird
from gibbonPerson
left outer join gibbonRole on gibbonRole.gibbonRoleID = gibbonPerson.gibbonRoleIDPrimary
where gibbonPerson.languageFirst = ‘French’
Sylvain
Gibbon : v25.0.01, PHP v8.1.2, MySQL v8.0.35, Ubuntu 22.04.3
2 Likes