If you leave out the part saying
// Add group
CriteriaGroup cg = new CriteriaGroup();
it should be enough to give you the result you seek. But also with grouping it returns the correct result according to my tests.
For your convenience there is already a method for this, ClubHandler.GetMyClubs(...), it will also perform better and give you automatic cache invalidation than a dynamically created query would.
Brilliant! Thanks a lot.
This is probably very easy, but I can't get my club query to work! What I want is to simply get all clubs where a given user is member.
My current, not-working, query looks like this:
All help is _very_ appreciated!