I am trying to query some fields using inner query where
ChargentOrders__Transaction__c is my managed package and
Agreement__c is the parent and
ChargentOrders__Transaction__c is child.But i am getting error:
ERROR at Row:1:Column:69 Didn't understand relationship 'ChargentOrders__Transactions__r' 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.
[select Payment_Options__c,(select id,ChargentOrders__Amount__c from ChargentOrders__Transactions__r) from Agreement__c]