sort by field which is stored as string but sort as integer rails

Question

I made an error and generated my Item model with string field instead of integer. Here is my migration

class CreateItems < ActiveRecord::Migration
  def change
    create_table :items do |t|
      t.string :name
      t.string :url

      t.text :photo

      t.string :price


      t.timestamps null: false
    end
  end
end

But right now I want to sort my items by price field and rails sorts it bad way because it is stored as string. For example it thinks that price 9 is bigger than 1111111111. Right now I order them like this:

@items=Item.where(:category_id => @active_category_id).order(:price)

What do I do?

I found this answer to do that you want

Raúl Cabrera
– Raúl Cabrera

2021-07-13 09:44:02 +00:00
Commented Jul 13, 2021 at 9:44 — Raúl Cabrera
– Raúl Cabrera, Commented Jul 13, 2021 at 9:44

Leantraxxx · Accepted Answer · 2016-03-19 22:45:21Z

2

Fix the column type. You can do it with the following migration:

class ChangePriceTypeInItems < ActiveRecord::Migration
  def change
    change_column :items, :price, :integer
  end
end

The data in price column will be preserved if the string contained represents an integer value.

By the way, I think a price needs to be a decimal not an integer. But, you choose.

edited Mar 19, 2016 at 22:45

answered Mar 19, 2016 at 21:48

Leantraxxx

4,6163 gold badges42 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

toddmetheny · Accepted Answer · 2016-03-19 22:13:33Z

1

try this:

@items = Item.where(category_id: @active_category_id).sort { |a, b| b.price.to_i <=> a.price.to_i }

this gets all with your category id and then compares the prices as integers instead of strings. It should give you the order you're looking for.

edited Mar 19, 2016 at 22:13

answered Mar 19, 2016 at 21:37

toddmetheny

4,4721 gold badge25 silver badges41 bronze badges

1 Comment

Benjamin W. Over a year ago

While this code may answer the question, providing additional context regarding why and/or how this code answers the question improves its long-term value.

Collectives™ on Stack Overflow

sort by field which is stored as string but sort as integer rails

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related