Below is the Query I’m using and I’m getting below error… Can you please let me know what this error means
I’m trying to get data from Account object with CVR__c (Customer Visit Report) object.
SELECT Id, Name, (SELECT Id, Visit_Date__c from CVR__c WHERE LastModifiedDate >= LAST_N_DAYS:7) FROM Account
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service service:TestCustomSOQLwithSubQuery.
[ADA.505.1011] API Fault occurred while executing the call [CustomQuery], Code: INVALID_TYPE, Message:
(SELECT Id, Visit_Date__c from CVR__c WHERE LastModifiedDate >=
ERROR at Row:1:Column:49
Didn’t understand relationship ‘CVR__c’ in FROM part of query call. 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.
However when I’m querying the above SELECT statements separately I’m getting results individually.
SELECT Id, Name FROM Account
SELECT Id, Visit_Date__c from CVR__c
These 2 queries working absolutely fine for me. It is my understanding that if there is an “__c” (underscore underscore) that means the object is custom object.