Rails Arel how group by select

user_4546646 0
Viewed 119

I want firstly add attributes with select and then order by them.

label = Arel.sql(
    %q(
        case label
        when 'x' then 1
        when 'y' then 2
        end
    )
)

Item.all.select("*, 'x' as label").order(label)

Error:

ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR:  column "label" does not exist)
LINE 2:       case label
arel ruby-on-rails ruby
1 Answers

Hard to figure out what the end result should be. You say GROUP BY, but I don't see what you're trying to group. I'm going to guess that you don't actually need to do this. You can also sort by multiple columns if that's what you're trying to do.

If you have to use Arel

Item.select(
      Arel.star, 
      Arel::Nodes::Case.new(Item.arel_table[:column_name]) 
       .when('x').then(1)
       .when('y').then(2)
       .as('label'))
    .order('label')

otherwise just use plain strings, you don't need to wrap it in Arel

Item.select("*")
    .select("CASE items.column_name WHEN 'x' THEN 1 WHEN 'y' THEN 2 END AS label")
    .order('label')

Do the logic in SELECT then sort by the result.

user_2070900
Related