You need to sign in to do that
Don't have an account?
Rajesh SFDC
how to sort names based on total field in apex
select id,Name,patientcount__c,Refferal_To_Count__c,color__c,CreatedDate,lastmodifieddate,Referral_Type__c from Account where Id IN : ac1 OR Id IN : ac2 order by Referral_Type__c asc, patientcount__c desc
1.Referral_Type__c is picklist . its working fine
2.patientcount__c is total based on total, i want to display the account names is Desc order , in this query its not working for me
1.Referral_Type__c is picklist . its working fine
2.patientcount__c is total based on total, i want to display the account names is Desc order , in this query its not working for me
Try implementing "Comparable" interface in your code to perform custom sort which gives you more flexibility in sorting. For reference, please follow the below link:
https://www.salesforce.com/us/developer/docs/apexcode/Content/apex_list_sorting_sobject.htm and refer "Custom Sort Order of sObjects" section in it.
Thanks,
Balaji