search

datasert / realfire

Refreshing Salesforce Data Management
https://www.datasert.com
3 stars 2 forks source link

Error with SOQL query #20

Closed jamesloughney closed 6 years ago

jamesloughney commented 6 years ago

The following SOQL query caused an error when it was run:

SELECT Id, ObjectId,Territory2Id, Object.Type, Territory2.Name, Territory2.ParentTerritory2.Name, Territory2.ParentTerritory2.Id, Territory2.Territory2TypeId FROM ObjectTerritory2Association WHERE Object.type = 'Account' ORDER BY ObjectId, LastModifiedDate DESC

This query works fine in the Developer Console.

Here is the error message I received: Error parsing [select Id, Object.Type, ObjectId, Territory2.Name, Territory2.ParentTerritory2.Id, Territory2.ParentTerritory2.Name, Territory2.Territory2TypeId, Territory2Id from ObjectTerritory2Association where Object.Type = 'Account']. Error: no viable alternative at input 'Object', no viable alternative at input 'Object'

brsanthu commented 6 years ago

Thank you, will take a look and update.

brsanthu commented 6 years ago

Version 4.3.6 is released with fix for this issue.