I need to be able to include spouses in some of my queries that I currently can not. I need to be able to include in a query to my board also the spouses of the board (who do not have the board code). Under "spouse" on a constituent query you can query on spouse relationships, spouse assigned appeals, spouse attributes - but not spouse memberships or spouse volunteer assignments. I need both.
My board memberships are in the volunteer module and my circle memberships are in the membership module (and the spouse has a joint membership but that is not queryable either!)
We need to be able to query the spouse membership information. We are running queries of those that are lapsed in the last 5 years and did not renew and the membership folks want to exclude people if their spouse happened to renew. We can't do this easily.