Active Member Constituency selection has incorrect results, and is showing a larger amount of constituents

The Active Constituencies section in an appeal mailing are selections that are built automatically by the system for all constituencies codes that exist. When using the Active Constituencies Member Constituents selection in an appeal mailing you may notice that the number of constituents included is larger than the amount of constituents that actually have the Constituency Member.
The Member Constituency may be pulling Constituents that might have previously had this Constituency.
This was resolved in the latest release of Altru.

Steps to Duplicate

To add the selection to an Appeal Mailing:
  1. In Marketing and Communications select Appeal Mailings.
  2. Select the mailing name to open the mailing.
  3. Select the Letters tab.
  4. Highlight the Letter and select Edit.
  5. Edit the selections of constituents that will receive this letter.
  6. Expand the Active Constituencies folder.
  7. Add 'Member' Constituents to the selection and click OK.
User-added image
8. Run the Appeal Mailing and notice that the results does not match the amount of constituent that have the Constituency Member.
​To create a query to find all Constituents with the Member Constituency and compare to the appeal selection:
  1. In Analysis select Information Library.
  2. Select Add an ad-hoc query.
  3. Highlight Constituents and click OK.
  4. Under browse for fields in highlight Constituencies.
  5. Drag Constituency from select constituencies fields to include records where.
  6. In the Apply Criteria window set this equal to Member.
  7. Preview Results.
  8. Notice that if you browse to some of the Constituent pages not all currently have the Member Constituency.


 Altru Arts & Cultural

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.