How to Resolve MALFORMED_QUERY: Semi join sub-selects are only allowed at the top level WHERE expressions… Sync Error¶
For users of the Email Sidebar on:
1 min read
In some cases, you may face a situation where your synchronization is not running, and the following error message is shown in Sync Settings Dashboard:
MALFORMED_QUERY: Semi join sub-selects are only allowed at the top level WHERE expressions and not in nested WHERE expressions.
The issue is related to the known Salesforce API limitation, which does not allow using the query with specific items. Usually, such queries are generated when the Salesforce Contacts List View with the Filter by Campaign Name is used in your organization.
How to address the issue¶
To resolve the described above synchronization error, you need to change the filter (sync scope) for down-syncing contacts from Salesforce to your mail client in Sync settings.
Important
Depending on your subscription plan, the appearance of your Sync Settings page may be different. Below you can find the troubleshooting steps described for the New and Legacy Sync Settings pages. Proceed with the steps according to the appearance of your Sync Setting page:
Steps for the new Sync Settings page¶
1. Open RG Email Sidebar, click Menu and go to Open Revenue Grid in browser
2. Click on your profile picture in the upper right-hand side corner, then go to Settings > Sync section
3. On the opened Sync Settings page, find the Contacts card and click Customize scope
4. In the drop-down list, choose the desired Custom Salesforce view to synchronize only contacts available in the selected Salesforce view
5. Click Apply to save the changes
Once the Contact Filter configuration is done, you need to Enable or Force synchronization to check if the issue is resolved.
Steps for the legacy Sync Settings page¶
1. Open RG Email Sidebar, click Menu and go to Sync Settings
2. On the opened Sync Dashboard page, go to Sync Setting > Filters
3. Find the Contacts card and click Customize in the bottom right corner of the card
4. Switch to the Custom view option
5. In the drop-down list, choose the desired Salesforce contact view to synchronize only contacts available in the selected Salesforce view
6. Click Save to apply the changes
Once the Contact Filter configuration is done, you need to Enable or Force synchronization to check if the issue is resolved.
If the issue still persists¶
If the troubleshooting steps described above have not resolved the synchronization issue, contact Revenue Grid support team for additional investigation and describe the steps you completed.