Hi everyone,
My question is: How do I override named_scope settings rather than merge
with them?
Say I have a model Vehicles
It has a named_scope called red_trucks that sets some filters and an
order by id.
Now lets say I want to find the unique values for an attribute.
So I might go
Vehicles.red_trucks.find(:all, “SELECT DISTINCT model_year”)
This breaks in postgres with the following error
“for SELECT DISTINCT, ORDER BY expressions must appear in select list”
ok, so lets add the model_year
Vehicles.red_trucks.find(:all, “SELECT DISTINCT model_year”,
:order=>“model_year”)
This still gives me the same error because the ‘order by id’ is still
there from the red_trucks name_scope. How do I override the order so it
because “model_year” instead of “model_year,id”?
Or is there a better way of doing this?