Hello,

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:

// Create a club query
ClubQuery clubQuery = new ClubQuery();

// Initialize criterions
clubQuery.Members = new MembershipCollectionCriterion();
clubQuery.Members.Containing = new MembershipCriterion();
clubQuery.Members.Containing.User = new UserCriterion();
clubQuery.Members.Containing.User.ID = new IntegerCriterion();
clubQuery.Members.Containing.MembershipType = new MembershipTypeCriterion();

// Set values to filter on
clubQuery.Members.Containing.User.ID.Value = ProfileMenuUser.ID;
clubQuery.Members.Containing.MembershipType.Value = MembershipType.Member;

// Add group
CriteriaGroup cg = new CriteriaGroup();
cg.AddCriterion(clubQuery.Members.Containing.User);
cg.AddCriterion(LogicalOperator.And, clubQuery.Members.Containing.MembershipType);
clubQuery.Members.Containing.AddCriteriaGroup(cg);

// Get the filtered clubs
ClubCollection clubs = ClubHandler.GetQueryResult(clubQuery);

All help is _very_ appreciated!

Thanks

/ jonas