Why does my Workspace record query return fewer results than the record count in my reports?
By design, Workspace record queries return only records that were updated within the last 365 days. Workspace transactional data for several objects are marked with a "Last Update Date" stamp that restricts the search to only 1 year. Any record that hasn't been updated for more than a year won't appear in the Workspace search results.
Other methods of reporting updated records outside of Workspace doesn't have this
restriction, hence the reason for differences in the record count. Here's a list of the
Workspace transactional objects:
- Activities
- Leads
- Opportunities
- Quotes and Orders
- Service Requests
Note: Workspace transactional object details are updated
asynchronously during Near Real-time Indexing.The asynchronous update happens after
the objects in the above list are refreshed.