Solved.
If anybody is having the same issue, the answer is to use "reorder" instead
of order.
Thank you all.
Sexta-feira, 16 de Maio de 2014 19:38:15 UTC-3, Henrique Vilela escreveu:
>
> 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
> <http://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/d53eb982-dd94-4b9c-b94f-f8e7a2753324%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
