You need to sign in to do that
Don't have an account?
Baz Denson
soql query of custom object and related object
I have a BRP_dealer__c object, and a dealer_productline__c related object.
I would like to pull all dealers and the product lines they hold into a list and serialize it into JSON.
I am currently trying this
But it doesnt work. How do I formulate this query?
Thanks
I would like to pull all dealers and the product lines they hold into a list and serialize it into JSON.
I am currently trying this
list<BRP_Dealer__c> dealerList = [SELECT id, city__c, CompanyName__c, Country__c, Email__c, Fax__c, LineTwo__c, PartyID__c, PersonName__c, postcode__c, state__c, Street__c, Telephone__c, TypeCode__c, Website__c, (select Id, name, brp_dealer__c from Dealer_ProductLine__r) FROM BRP_Dealer__c];
But it doesnt work. How do I formulate this query?
Thanks
All Answers
What difficulty are you facing while running this query ?
Thanks,
Govindaraj.S