Improve Your Constituent Searches
John Lyons
Blackbaud Employee
When you search for constituents, the search criteria that you enter on the Constituent Search screen directly impacts how long it takes to get your search results. For best results, we recommend that you are selective in your search criteria and that you enter detailed information. By providing detailed search criteria, you help to ensure that you get your search results in a timely manner.
In addition to this general rule, we also recommend that you consider the following tips before you enter search criteria.
In addition to this general rule, we also recommend that you consider the following tips before you enter search criteria.
- For the fastest search results, enter just the constituent's ID in the search screen's Lookup ID field.
- If you don't have a lookup ID, entering just a name in the Last/Org/Group name field is nearly as fast as the Lookup ID field.
Note: When you enter search criteria in both the Last/Org/Group name and ZIP/Postal code fields, search results are a bit slower. The combination of fields is useful for common last names, but you may want to search by just the last name for less common names. - If you place wildcards at the start of search fields, the search screen cannot use indexes and, therefore, search results are much slower. We recommend that you avoid wildcards at the start of search fields, especially the "%" and "*" wildcards that replace multiple characters.
- If you select Include fuzzy search on name, search results are noticeably slower. This checkbox is useful when you are unsure how to spell a name or suspect your spelling may not match the constituent record. However, when you are confident about how to spell a name, we recommend against using this checkbox.
0
Comments
-
I have been using those wildcards, but was not aware at the beginning of the search they would be so problematic.0
Categories
- All Categories
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 402 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 656 Blackbaud Grantmaking™
- 577 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 941 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.7K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 240 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 796 Community News
- 3K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
