In XL-Connector 365 version 1.8.8
- You now have an option to disable some of the report columns when pulling and refreshing reports from Salesforce:
- New possibilities with using Dynamic SOQL. The following syntax is now supported:
SELECT Id, Name, StageName FROM Opportunity WHERE Name LIKE {{A1:A3}}
When this is translated to the actual query, it will look as follows:
SELECT Id, Name, StageName FROM Opportunity WHERE Name LIKE ‘%A1Value%’ OR Name Like ‘%A2Value%’ OR Name Like ‘%A3Value%’
