{"id":6095,"date":"2012-08-10T17:42:38","date_gmt":"2012-08-10T12:12:38","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=6095"},"modified":"2016-11-29T17:30:35","modified_gmt":"2016-11-29T12:00:35","slug":"groovier-way-of-sorting-over-multiple-fields-in-a-list-of-maps-in-groovy","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/groovier-way-of-sorting-over-multiple-fields-in-a-list-of-maps-in-groovy\/","title":{"rendered":"Groovier way of sorting over multiple fields in a list of maps in groovy"},"content":{"rendered":"

Recently I was working on a Groovy and Grails Development<\/a> project and had a requirement to sort multiple fields in a list of maps.<\/p>\n

I needed to sort the below list of maps by firstName, then by lastName and then by ascending age. It means first, the firstNames will be compared. If they are same, lastNames will be compared and even if they are same, ages will be compared to decide order.<\/p>\n

[java]
\nList list = [
\n [id:0, firstName: ‘Sachin’, lastName: ‘Tendulkar’, age: 40 ],
\n [id:1, firstName: ‘Sachin’, lastName: ‘Tendulkar’, age: 103 ],
\n [id:2, firstName: ‘Ajay’, lastName: ‘Tendulkar’, age: 48 ],
\n [id:3, firstName: ‘Virendra’, lastName: ‘Sehwag’, age: 5 ],
\n [id:4, firstName: ‘Virendra’, lastName: ‘Sehwag’, age: 50 ],
\n [id:5, firstName: ‘Sachin’, lastName: ‘Nayyar’, age: 15 ]
\n]
\n[\/java]<\/p>\n

One way to achieve this is to use spaceship operator as follows :<\/p>\n

[java]
\nlist.sort { a,b ->
\n a.firstName <=> b.firstName ?: a.lastName <=> b.lastName ?: a.age <=> b.age
\n}*.id
\n[\/java]<\/p>\n

which gives the correct output as a list of id’s = [2, 5, 0, 1, 3, 4]<\/p>\n

One cool groovier way<\/a> of achieving the same result is to concatenate firstName,lastName and age fields as a single string and then use the resulted string in sorting. However, there will be a problem with sorting age in this manner. Among two ages, 40 and 103, groovy will treat 103 as lower than 40, because sorting is done in ASCII\u00a0collating sequence and in that 1 of 103 comes before 4 of 40.<\/p>\n

One way to rectify this problem is to left-pad the age with sufficient number of 0’s before it is compared. Thus, 40 will become 040 and 103 will remain as it is and we will get the correct ordering. (Special thanks to my colleague\u00a0Bhagwat<\/a>\u00a0for helping me to arrive at this solution)<\/p>\n

[java]
\nString padAge(Integer age){
\n return String.format("%03d",age)
\n}
\n[\/java]<\/p>\n

In format “%03d”, 0 specifies the filler digit and 3 specifies the maximum number of digits after padding. Thus, our final one-liner to perform sorting over multiple fields becomes :<\/p>\n

[java]
\nlist.sort{it.firstName+it.lastName+padAge(it.age)}*.id
\n[\/java]<\/p>\n

and output will be [2, 5, 0, 1, 3, 4]<\/p>\n

I\u00a0Hope it will be helpful.<\/p>\n","protected":false},"excerpt":{"rendered":"

Recently I was working on a Groovy and Grails Development project and had a requirement to sort multiple fields in a list of maps. I needed to sort the below list of maps by firstName, then by lastName and then by ascending age. It means first, the firstNames will be compared. If they are same, […]<\/p>\n","protected":false},"author":46,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":261},"categories":[7],"tags":[859,858,505],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/6095"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=6095"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/6095\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=6095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=6095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=6095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}