Querying several groups from the membership administration can sometimes be a bit of a mission. It is important to know exactly what it is that you want to find and how to formulate the query correctly. Using several examples, we will try to explain the difference between 1-1 and 1-N queries.
| Query demand | Group 1-1 | Group 1-N |
| Group A member | Correct | Correct |
| Group B member | Correct | Correct |
| Group A or B member | Correct | Correct |
| Group A and B member | Incorrect | Correct |
| Group A member, non-member group B | Incorrect | Correct |
| Non-member group A and B | Incorrect | Correct |
Why still use the 1-1 query if group 1-N always returns the desired result? It is better to use 1-1 if you intend to display the Group or Group item on the report. This is caused by the different way in which a 1-1 query functions from a 1-N query.
For example, somebody is a included in several groups, one of which is the Coach group. The 1-1 query will also display the group coach in the report.
The Group 1-N query displays the same names but the Group and Group item fields can be random.
The report generator has been expanded with Group list 1-N and Group item list 1-N. This allows you to select more than one group or items simultaneously instead of one group or one item only.
In this file: Rapportgenerator 1-1 1-N you'll find multiple examples.
e-Captain has a very extensive Member Management package. We offer several basic trainings which teach you to work with e-Captain in an accessible way. The trainings take place at our office in 's-Hertogenbosch.
To be able to support you optimally, it can be easy to look with you on your computer from a distance. We use TeamViewer to do this. TeamViewer makes it possible to take over your computer from a distance.
