Thank you Matt,
It kind for work. It added a new order item instead of replace it.
class Pattern < ActiveRecord::Base
default_scope { order('sort, title') }
has_and_belongs_to_many :children,
-> { order('patterns_patterns.id') },
:class_name => 'Pattern',
:join_table => 'patterns_patterns',
:association_foreign_key => 'child_id',
:foreign_key => 'parent_id'
end
*... ORDER BY sort, title, patterns_patterns.id *
Any idea?
Sexta-feira, 16 de Maio de 2014 9:27:18 UTC-3, Matt Jones escreveu:
>
>
>
> On Thursday, 15 May 2014 09:56:11 UTC-4, Henrique Vilela wrote:
>>
>> Hi Colin, thank you for your answer.
>> I just realized that my problem is bigger than that. I removed the
>> default_scope and my query now is "orderbyless".
>>
>> SELECT "patterns".* FROM "patterns" INNER JOIN "patterns_patterns" ON
>> "patterns"."id" = "patterns_patterns"."child_id" WHERE
>> "patterns_patterns"."parent_id" = ? [["parent_id", 7]]
>>
>> Why the order is been ignored?
>>
>> class Pattern < ActiveRecord::Base
>>
>> has_and_belongs_to_many :children,
>>
>> :class_name => 'Pattern',
>>
>> :join_table => 'patterns_patterns',
>>
>> :association_foreign_key => 'child_id',
>>
>> :foreign_key => 'parent_id',
>>
>> :order => 'patterns_patterns.updated_at'
>>
>> end
>>
>>
> The `order` option was removed a while back - things that change the query
> should be done in a scope lambda instead:
>
> has_and_belongs_to_many :children, -> { order(:something) }, ...
>
> --Matt Jones
>
>
>
>> Quinta-feira, 15 de Maio de 2014 5:34:26 UTC-3, Colin Law escreveu:
>>>
>>> On 14 May 2014 19:13, Henrique Vilela <[email protected]> wrote:
>>> > I'm trying to set a specific order to an association, but I keep
>>> getting the
>>> > default scope order definition.
>>> >
>>> > What am I missing?
>>>
>>> I tend to avoid default_scope for exactly this reason, the results are
>>> not always obvious. I prefer to use named scopes or specify the order
>>> explicitly. Then you have better control of what is going on. Many
>>> believe default scopes are evil. I believe you can override it using
>>> reorder.
>>>
>>> Colin
>>>
>>
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/26f67aae-b91a-414b-80b4-1820ab46d1d6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
