The query builder module is a wonderful extension of gibbon and really powerful. However, I wasn’t able to figure out, how I can execute multiple queries in one go. I want to create a school summary report containing multiple data.
- Number of students in the current school year
- Number of girls/boys per year group
- Number of girls/boys per year group and 6 years old
- Number of girls/boys per year group and 7 years old
- Number of girls/boys per year group and 8 years old
An interesting option would be to suppress all results returning 0 records.
This is a good question. You could try and use the UNION statement in SQL to bring together multiple SELECTS into a single statement.
In this case, though, check out People > Students in the main menu and then the report Age & Gender Summary in the sidebar menu. I think this returns what you are after, in a pre-tabulated form.
Thanks for these suggestions!
Let me do a few tests. I will then get back to you.
You guys are incredible! The Age & Gender Summary is doing exactly, what I needed!
Really well done!
Roman, happy to please : ) The HK government mandates schools return an annual survey, and this spits out part of the results for us, saving us doing it by hand. Yay! Ross.
Ross, same here, same here. We call it the annual school census or annual PITA, sorry…