Hi,
I am trying to build a query using Query Builder, but am getting an error message:
SELECT AcctSeed__Account__r.Name, Advertiser__r.Name, AcctSeed__Cash_Receipt__r.Name ^ ERROR at Row:1:Column5 Didn't understand relationship 'Advertiser__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
I am selecting the fields from the left, so not sure why I would be getting this message when the SQL should be generated correctly for me using this method.
Thanks,
Jennifer