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
Jeff_Rogers.ax1383Jeff_Rogers.ax1383 

Return SOQL Results for Related Objects in Order

Say I have an Opportunity, how do I return the results for that opportunities OpportunityLineItems in order that they appear in the related list on the opp page?

 

Thanks!

sfdcfoxsfdcfox

Sort by the SortOrder field...

 

select ... from opportunitylineitem where opportunityid = :oppid order by sortorder
Jeff_Rogers.ax1383Jeff_Rogers.ax1383

Does the sortorder field work on custom objects?  I have a "Case Product" custom object related list on the Case object and am getting the following error when using sortorder in my soql query:

 

No such column "SortOrder" on entity 'Case_Product__c'

 

The Apex version on this class is 25.
Jeff_Rogers.ax1383Jeff_Rogers.ax1383

Anyone???