query on spouse volunteer data and membership data

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!)

  • Guest
  • Jan 5 2015
  • Attach files
  • Guest commented
    March 09, 2018 20:22

    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.