The latest articles on DEV Community by Sagar Patil (@sagar18041). https://dev.to/sagar18041 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F293653%2F6d5ac1e0-fd08-4f0d-8667-06f326095ce7.jpeg https://dev.to/sagar18041 en Sagar Patil Wed, 28 Oct 2020 05:09:44 +0000 https://dev.to/sagar18041/rails-6-1-supports-order-desc-for-findeach-findinbatches-and-inbatches-58mn https://dev.to/sagar18041/rails-6-1-supports-order-desc-for-findeach-findinbatches-and-inbatches-58mn <p>Rails 6.1 now supports <em>ORDER BY</em> id for ActiveRecord batch processing methods like <em>find_each</em>, <em>find_in_batches</em>, and <em>in_batches</em>. This would allow us to retrieve the records in ascending or descending order of ID.</p> <p><strong>Points to remember:</strong></p> <ul> <li>The <em>ORDER BY</em> clause only works with the primary key column.</li> <li>Valid values for the <em>ORDER BY</em> clause are <em>[:asc,:desc]</em> and it’s case sensitive. </li> <li>If we use caps or title case (like DESC or Asc) then we’ll get an <em>ArgumentError</em>.</li> </ul> <p><a href="https://blog.bigbinary.com/2020/10/22/rails-6-1-supports-order-desc-for-find_each-find_in_batches-and-in_batches.html">Read more</a></p> rails sql