Controlling data with SmartList record limits
When running a SmartList, the number of records returned by the SmartList is shown in the bottom left. By default, SmartLists have a record limit of one thousand (1,000) records. When the number of transactions matches the maximum, it's likely that there are more transactions not being shown. If the SmartList shows 1,000 bank transactions returned and the criteria shows first 1000 records, it's unlikely that there are exactly 1,000 bank records. In almost all cases, there are more than 1,000 records and the limit should be raised:
The idea behind this default limit is to prevent long-running SmartList queries from slowing down the system. However, sometimes it makes sense for queries to return more than a thousand records.
There are a few options for increasing or decreasing this record limit, including adjusting it on the fly, adjusting the limit for Favorites, and setting a new default limit. We'll take a look at all of these...
