• Vince Fallourd
  • NEWBIE
  • 5 Points
  • Member since 2015
  • Senior Solutions Architect
  • Astra


  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
I have a visualforce table I'd like to see sorted on a field that reside on a child object. 
I have maps and list to link the objects. I have an "order by" statement on the child soql query but it doesn't work. 
Somehow this could be an easy one but not for a code noob like me. 
Here's how my code is:
MMList = [SELECT Id,(...) FROM Parentobject__c WHERE Status = "xyz"]
for(childObject__c COname : [SELECT Id,Name,(...) FROM childObject__c WHERE RecordTypeId = 'someid' AND Parentobject__c IN: MMList ORDER BY Name ASC ]){
            (....mapping code)

How do I make the order by statement action the sorting?
Thank you for your help, hours of online research and multiple version returned no result. 
I can show more code from the wrapper class. It is working great otherwise. 
 
Hello, 
Please can someone help me with the this error? I am using dataloader to insert contact data into Salesforce: ERROR: dlrs_ContactTrigger: System.LimitException: dlrs:Too many query rows: 50001

Thanks.