| Status | Done | Related work item | MIC-3918 |
| Description | Some searches in Account Search might throw the following error: Aggregate query has too many rows for direct assignment, use FOR loop This is due to a Salesforce query limitation when querying large numbers of related records. Salesforce describes this in the following two Knowledge articles: - Aggregate query has too many rows for direct assignment but less than 200 rows - 'Aggregate query has too many rows for direct assignment, use FOR loop' error This happens in when both of the following are true: 1. There are long or rich text fields in the account query and 2. Any single account in the search results has more than 200 Contact Information or 200 Affiliation records related to it | | |
| Affects version(s) | V14, V14.1, V15 | Impacted capabilities | |
| Steps to reproduce | 1. Perform an account search using Account Search V3, where over 200 Contact Information or Affiliation records are returned. | | |
| Workaround | There are two possible workarounds for this issue: 1. Make sure accounts do not have more than 200 Contact Information records or affiliated to more than 200 other accounts. 2. Remove user FLS to all long text and rich text fields on the following objects: - Account - Contact - Contact Information - Affiliation | | |
| Fix version | V16 | Resolution notes | N/A |