If the eTapestry database contains over 25,000 accounts, running the duplicate report on the entire database could take more than 5 hours. So, in order to ensure it displays and finishes running, the query used for the duplicate report is limited according to the following criteria:
• 25,001 - 50,000 Accounts - your query must contain less than 10,000 accounts. • 50,001 or more Accounts - your query must contain less than 2,500 accounts.
This means depending on how many total accounts are in your database, your query results must contain less than 10,000 or less than 2,500 results.
Even though the query used when running the duplicate report isolates only a portion of the database the duplicate report will still look for possible duplicates accounts outside the results of the query.
For example, if you were to query on accounts that may have been "created" in the past month. This query may only gather 100 accounts. If you were to run the duplicate report using that query, the duplicate report will search for possible duplicates in the entire database and return those that may be possible matches for the 100 accounts found by your query.
If your organization needs to isolate a specific number of accounts, the simplest way to restrict your query is by using a criteria that restricts accounts by a range of account numbers.
You can set up a query that restricts by account number as follows:
1.Select Queries in the menu bar 2.Click on a category that you want to store this query in 3.Click New Query under the tasks menu 4.Name the query 5.Set the Starting criteria to Base/All Constituents 6.Set the Data Return Type to Accounts 7.Set the Match to All Of My Criteria 8.Choose Account from the Available Fields drop down menu and click on Account Number 9.Fill in Greater Than Or Equal To / 1and Less Than Or Equal To / 10000 10.Click Save and Preview
Segmenting your database into a handful of queries will allow you to run your duplicate report on your entire database after a few iterations.
* Note: To isolate a specific number accounts, the 'account number' range may need to be adjusted. Account Numbers are not re-used. If you delete or merge an account, that account number is not reassigned to a new account. So if you query on account numbers 1,000 - 2,000, you many not end up with 1000 accounts in the query results.