function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vfexp31.3955631467313875E12vfexp31.3955631467313875E12 

Called Child Filed Values From Parent

HI,
   
          I have 2 objects Quote,Quoe-line-item i want to call the line item fields from Quote by using soql query may i know how can i call the child fields from parent object
Ramu_SFDCRamu_SFDC
You can use a query something like  SELECT Id, (SELECT Id from quotelineitem) FROM quote include all the fields you need from quote line items in the sub query.

For more examples on queries refer to :  http://simplysfdc.blogspot.com/2013/09/salesforce-soql-query.html
vfexp31.3955631467313875E12vfexp31.3955631467313875E12
@Ramu

    It Showing An error
 
       Didn't understand relationship 'Quote_Item__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.
Martha_SenetaMartha_Seneta
Try this - similar to what Ramu_SFDC posted, but make sure to include the 's' at the end of QuoteLineItems:

SELECT Id, (SELECT Id FROM QuoteLineItems) FROM Quote

If you're still having trouble, could you please post the entire query here?
Ramu_SFDCRamu_SFDC
my bad. Thanks Martha :)