On Jueves, 25 de Junio de 2009 08:06:59 G. Sobrinho escribió: > / Sorry, i sended without the second part... > > So, the database sort by id none is specified. The ActiveScaffold doesnt > need to add the order clause.
No, it depends on database engine, I have got different results sometimes with queries without order. Databases usually returns records in disk order when query has no order clause, and with partitioned tables the default order is random (for example in mysql cluster all tables are partitioned). Oracle documentation says "If you do not include an ORDER BY clause then the order of the result set rows will be unpredictable (random or quasi random)." So IMO it's good adding order by id when there is no order (not adding it could break pagination) if you can disable it (you can with config.columns[:id].sort=false) > > If I explicit a sort column (clicking on header of column or setting in > controller), the AS needs to add the clause. Othewise, no. > > I think this is the best form. > > 2009/6/25 G. Sobrinho <[email protected]> > > > But the databases, by default, sort by id if nothing is specified. So, > > the ActiveScaffold dont need to set it which avoid the defaut_scope in my > > situation. > > > > > > 2009/6/24 <[email protected]> > > > >> Yes sort of? > >> > >> See active scaffold adds sort by id by default unless you tell it to do > >> differently. > >> You told your model to have some default scopes as well. The order in > >> which these are added must be active scaffold scope first, default_scope > >> second, because the id scope shows up higher in priority. > >> > >> I believe you can turn off the sorting by id, > >> > >> config.columns[:id].sort = false > >> > >> or something like that, it might be config.list.columns[:id].sort = > >> false > >> > >> ~kenny > >> > >> Sent from my Verizon Wireless BlackBerry > >> > >> ------------------------------ > >> *From*: "G. Sobrinho" > >> *Date*: Wed, 24 Jun 2009 23:39:37 -0300 > >> *To*: <[email protected]> > >> *Subject*: Re: Order of records with default_scope > >> Yes, the id ASC are added because ActiveScaffold tryed to sort by it. > >> > >> But by default, in theory, the Active Scaffold can't sort the records by > >> any fields except I explicited it. Not? > >> > >> 2009/6/24 <[email protected]> > >> > >>> I belive active scaffold tries to order by I'd by default so it is > >>> adding it. > >>> > >>> I would use the config sort that active scaffold provides for you, look > >>> at the list config wiki page for examples > >>> > >>> Sent from my Verizon Wireless BlackBerry > >>> > >>> ------------------------------ > >>> *From*: "G. Sobrinho" > >>> *Date*: Wed, 24 Jun 2009 19:07:39 -0300 > >>> *To*: activescaffold<[email protected]> > >>> *Subject*: Order of records with default_scope > >>> Hello, > >>> > >>> I'm using default_scope on some models to sort the records but the AS > >>> have a issue with that. > >>> > >>> For example, i have a model named Page: > >>> > >>> class Page < ActiveRecord::Base > >>> default_scope :joins => :category, :order => 'categories.order ASC, > >>> pages.order ASC' > >>> end > >>> > >>> > >>> When I access the list, the SQL generated is (order part): "ORDER BY > >>> pages.id ASC, categories.order ASC, pages.order ASC" > >>> But I don't setted the AS to sort by id. Well, this doesn't work. > >>> > >>> It's a bug? > >>> > >>> > >>> Thank you > >>> > >>> -- > >>> Regards, > >>> > >>> Gabriel Sobrinho > >>> E-mail: [email protected] > >>> Phone: +55 31 8775 8378 > >>> > >>> Don't print this e-mail. The nature is thankful and your money also. > >> > >> -- > >> Regards, > >> > >> Gabriel Sobrinho > >> E-mail: [email protected] > >> Phone: +55 31 8775 8378 > >> > >> Don't print this e-mail. The nature is thankful and your money also. > > > > -- > > Regards, > > > > Gabriel Sobrinho > > E-mail: [email protected] > > Phone: +55 31 8775 8378 > > > > Don't print this e-mail. The nature is thankful and your money also. -- Sergio Cambra .:: entreCables S.L. ::. Mariana Pineda 23, 50.018 Zaragoza T) 902 021 404 F) 976 52 98 07 E) [email protected] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
