You need to sign in to do that
Don't have an account?
Vince Fallourd
Sorting table using child object field.
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.
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.