Rails default_scope based on some value

Question

I have a model Post. I want to show first posts where name is 'esa' then order by updated_at.

I tried this in post.rb but doesn't work:

default_scope {Post.where(name: 'esa') && order(updated_at: :desc) }

`default_scope` is often discouraged and this use is even more bizarre. Are you positive you want all requests to the `posts` table be filtered and ordered this way? — ndnenkov, Dec 19 '16 at 09:02

Nikita Misharin · Accepted Answer · 2016-12-19T09:16:20.463

0

That would be rather ugly, but here it is.

default_scope do
  order("CASE WHEN name = 'esa' THEN 0 ELSE 1 END").order(updated_at: :desc)
end

edited Dec 19 '16 at 09:16

answered Dec 19 '16 at 09:00

Nikita Misharin

this shows me just post with name esa not other posts.. – Nda.S Dec 19 '16 at 09:03
@Nda.S because this is how querying works, - it returns you a collection of items that match the criteria you passed, in your particular case to `where` clause – Andrey Deineko Dec 19 '16 at 09:10
@AndreyDeineko I want to show me first posts with name esa, and then other post ordered by updated_at – Nda.S Dec 19 '16 at 09:11
1

@NikitaMisharin it worked, thanks!!! – Nda.S Dec 19 '16 at 09:21

1 Answers1