Skip to main content

Filter for Specific Accounts

Use the Find Constituents filter to search for and filter by specific accounts. This filter is useful when you want to include certain constituents who don't share a common criterion. For example, you might need to copy certain board members or staff on an email even though they don't meet the other filter criteria. You can select as many constituents as you need within a single filter.

Filter for Constituents

Search for individuals, organizations, or households. You must type in at least three characters before a search result is listed.

To filter for specific constituents in a report:

  1. Create or edit a constituent report.

  2. Click Add Filter.

  3. Search for and select Find Constituents.

  4. Enter a constituent or household’s name. Possible matches appear. Households are indicated by a house icon.
    Filter for Find Constituents

  5. Select the constituent. To avoid duplicates, if you select a constituent or household, it no longer appears in the results.

  6. Search for and add more constituents.

  7. Click Apply.

Running the report to household will list households where any member is included in the filter. Constituents not in a household are listed individually.

Show Household Members

When filtering by household and the report is not run to households, the report shows all members of a household.

To filter for a specific household and show all household members:

  1. Click Add Filter.

  2. Search for and select Find Constituents.

  3. Search for and select the household.Find Constituents filter and a selected household

  4. Click Apply.
    Find Constituents filter for a household with all members shown in the report results

Filters with Deleted or Merged Constituents

Sometimes we filter for constituents that are then deleted or merged.

  • If an account is being used in a filter and that constituent is merged into another account, the filter will show the account that was kept from the merge.

  • If an account is being used in a filter and that constituent is deleted, the filter shows Deleted Account instead of the constituent’s name.

  • If all accounts used in a filter are deleted, the filter shows Constituent is a value that does not exist, and returns zero results.

Did this answer your question?