This error occurs due to a Salesforce SOQL limitation. Salesforce only allows a maximum of two semi-join sub-selects in a single query. When you create a filter in Apsona with an “OR” condition nested inside parentheses involving child objects, it can exceed this limit.
Example Problem:
Filter logic used: (1 OR 2) AND 3
Salesforce does not allow this specific nesting of the “OR” condition when combined with semi-joins, which causes the error.
Recommended Solution:
Rewrite the filter logic to avoid nesting, for example: (1 AND 3) OR (2 AND 3)
This maintains the intended result while staying within Salesforce’s SOQL limits.
Resolution:
Updating the filter logic in this way resolves the “EXCEEDED_MAX_SEMIJOIN_SUBSELECTS” error and allows the report to run successfully.