How to sort list items for Date field value (Apex, Salesforce)

Sort a List of Objects by Date - java - Stack Overflow Home Public Questions Tags Users Collectives ExploreCollectives FindaJob Jobs Companies Teams StackOverflowforTeams –Collaborateandshareknowledgewithaprivategroup. CreateafreeTeam WhatisTeams? Teams CreatefreeTeam CollectivesonStackOverflow Findcentralized,trustedcontentandcollaboratearoundthetechnologiesyouusemost. Learnmore Teams Q&Aforwork Connectandshareknowledgewithinasinglelocationthatisstructuredandeasytosearch. Learnmore HowtosortlistitemsforDatefieldvalue(Apex,Salesforce) AskQuestion Asked 9years,11monthsago Active 3years,9monthsago Viewed 18ktimes 1 WithSalesforce'sApex,isthereanywaytosortlistitems,forDatefieldvalue.PleaserefertheTODOsectionofthefollowingcode,thanks. /** *SelectlistofjobOccurrencesbelongstoparticularlistofjobs */ privateListgetJobsByJobCode(ListjobList){ //SelectrelevantJobOccurrenceobjects ListjobOccuList=newList(); for(Job__cjob:jobList){ Job_Occurrence__cjobOccurrence=[SELECTId,Job__c, Schedule_Start_Date__c FROMJob_Occurrence__c WHEREJob__c=:job.Id]; if((jobOccurrence!=null)&&(jobOccurrence.Id!=null)){ jobOccuList.add(jobOccurrence); } } if((jobOccuList!=null)&&(jobOccuList.size()>0)){ //TODO //HowIsortthe'jobOccuList'withDatefield'Schedule_Start_Date__c', //forselecttheitemsaccordingtosequenceoflatestjobOccurrence returnjobOccuList; }else{ thrownewRecordNotFoundException('CouldnotfoundanyjobOccurrenceforgivenlistofjobs'); } } apex-code Share Follow askedMar22,2012at5:24 ChannaChanna 4,4111414goldbadges5656silverbadges9696bronzebadges Addacomment  |  2Answers 2 Sortedby: HighestScore(default) Datemodified(newestfirst) Datecreated(oldestfirst) 4 Youreallyshouldbulkifythiscode,i.e.notrunaqueryinsidealoopwhichcouldcausepotentiallycauseissueswiththegovernorlimits,andsinceyoujustwantthecombinedlistforallJob__crecordsthismakesyourorderingeasytoo— youcandoitinthequery! Thecodeyouwanttochangeisthis: //SelectrelevantJobOccurrenceobjects ListjobOccuList=newList(); for(Job__cjob:jobList){ Job_Occurrence__cjobOccurrence=[SELECTId,Job__c, Schedule_Start_Date__c FROMJob_Occurrence__c WHEREJob__c=:job.Id]; if((jobOccurrence!=null)&&(jobOccurrence.Id!=null)){ jobOccuList.add(jobOccurrence); } } EssentiallywecanoptimisethistonotonlyuseonequeryinsteadofN(whereNisjobList.size())andgetthemorderedatthesametime.FirstweneedtogatherthelistofJob__cIDs,andthenwecanusetheINstatementintheWHEREclauseoftheSOQL: //SelectrelevantJobOccurrenceobjects ListjobOccuList; SetsetJobIds=newSet(); setJobIds.addAll(jobList); //getthejoboccurancesstartingwiththelatest,useASCforreverse! jobOccuList=[SELECTId,Job__c,Schedule_Start_Date__c FROMJob_Occurrence__c WHEREJob__cIN:setJobIds ORDERBYSchedule_Start_Date__cDESC]; Finally,ifyouneedtobeabletoeasilymapbackfromtheJob_Occurrence_crecordstoJob_crecords,youcouldreplacethesetwithamapasbelow,thoughgiventhatyoujustwantthislistIdon'tthinkit'sneededhere(justprovidingitforcompleteness). MapmapJobs=newMap(); for(Job__cjob:jobList){ mapJobs.put(job.Id,job); } **snip** for(Job_Occurrence__cjobOccu:jobOccuList){ Job__ctheJob=mapJobs.get(jobOccu.Job__c); //dostuffwiththejob } Allofthiscodehasbeenwritteninbrowser,sotheremaybesomesyntaxerrorsbutitshouldbegood! Share Follow editedMay21,2012at23:22 answeredMar22,2012at9:21 MattLaceyMattLacey 8,1373131silverbadges5757bronzebadges 3 HiLaceySnr!Thanksalotforyourvaluableanswer.Haveanicetime! – Channa Mar22,2012at9:38 1 IliketheuseofsortingintheSOQLqueryratherthanincode.AslightimprovementherecouldbetoswaptheloopthataddslistitemstothesetforusingsetJobIds.addAll(jobList); – Born2BeMild May21,2012at21:30 Goodspot!Updatedthesampletoreflectthis. – MattLacey May21,2012at23:31 Addacomment  |  -2 Youcantry: liDates.sort(); It'sworkingforme. Cheers Share Follow editedMar25,2012at23:28 answeredMar25,2012at23:23 CloudNinjaCloudNinja 16799bronzebadges Addacomment  |  YourAnswer ThanksforcontributingananswertoStackOverflow!Pleasebesuretoanswerthequestion.Providedetailsandshareyourresearch!Butavoid…Askingforhelp,clarification,orrespondingtootheranswers.Makingstatementsbasedonopinion;backthemupwithreferencesorpersonalexperience.Tolearnmore,seeourtipsonwritinggreatanswers. Draftsaved Draftdiscarded Signuporlogin SignupusingGoogle SignupusingFacebook SignupusingEmailandPassword Submit Postasaguest Name Email Required,butnevershown PostYourAnswer Discard Byclicking“PostYourAnswer”,youagreetoourtermsofservice,privacypolicyandcookiepolicy Nottheansweryou'relookingfor?Browseotherquestionstaggedapex-codeoraskyourownquestion. TheOverflowBlog TwiliolaunchesCollectiveonStackOverflow Stopaggregatingawaythesignalinyourdata FeaturedonMeta WhatgoesintositesponsorshipsonSE? StackExchangeQ&AaccesswillnotberestrictedinRussia UpcomingFeatureTest:AskWizardforNewUsers Linked 2 easytriggertorankdatesandinsertrank-apex-salesforce Related 2 easytriggertorankdatesandinsertrank-apex-salesforce 0 Writingatestcaseinapexsalesforceforthetrigger 1 SalesforceApex:Validatingdateforformatandvalue 0 unabletogetSalesforceApexmaptolist 3 MaximumSizeofListinAPEXSalesforce 2 gettingValueofafieldbyitsNameinapexsalesforce 0 customapexcontrollerforsalesforce 1 SalesforceApex:DateStringtoDateIssueinDynamicQuery 1 ModifyingTask'Name'fieldwithApex/Salesforce 0 CreatingaSalesforceApexTriggertoupdatealookupfieldintheContactsobject HotNetworkQuestions Needmotorinthemiddle Howtoreduce/mitigatethedegreetowhichaStarlinkterminaluserinawarzoneisgivingtheirpositioninrealtime? Crateartstacking HowtotacklethisVRPvariant? CanIrunbothaprimaryandsecondaryDNSserverusingthesamepublicIP? Howtopreventdampitemsfromgettinggrossinluggage Symbolfor\ggorequal Shortstoryconcerningadangerousinkblot HowdidearlyvideoterminalsconvertASCIIintofontgraphics? Canatortlebecomeproficientwiththieves’toolsiftheyhavelargefingersandlongclaws? Whatisthefrequencyofthesound? PotentialcounterexamplestoBass'traceconjecture Howlongdoesittaketotrainacommercialpilottoflyafighterjet? Outputarandomunarystring Howdoyousolvevaguemateintwoproblems? Adverbialclauseasantecedentofpronoun? GamblingwithanAlien Describingthedifferencebetweenamassandanopera? Whatwouldcausehorse-ridingcavalrytoreturn? AtwhatdatarateshouldweconsiderPCBviabackdrilling?HowaboutflexPCB? TowhatdoesUSArmyLt.GeneralH.R.McMasterrefersayingthatGermany'sSocialDemocraticPartyhasa'deepandunnaturalaffinity'forRussia? Designingarailguntodisableman-portablefirearms Isitpoliticallyacceptabletoincentivizesoldiersofanothercountrytodefect? IsthereaGermancolloquialismtodefineapersonworkingmainlywithpapersanddocuments? morehotquestions Questionfeed SubscribetoRSS Questionfeed TosubscribetothisRSSfeed,copyandpastethisURLintoyourRSSreader. Yourprivacy Byclicking“Acceptallcookies”,youagreeStackExchangecanstorecookiesonyourdeviceanddiscloseinformationinaccordancewithourCookiePolicy. Acceptallcookies Customizesettings