db.search_form.pet_type_ref.requires = IS_IN_DB(db,'pet_type',orderby=db.pet_type.description)
OR this may work too: db.search_form.pet_type_ref.requires.orderby = db.pet_type.description On Thursday, 24 April 2014 07:31:40 UTC-5, M Bailey wrote: > > I'm trying to migrate a django project to web2py. I have defined a search > form with <select><option> fields populated from the database and using > code similar to below, but I can't see a way of changing the ordering of > the SQLFORM fields: > > db.define_table('pet_type', > Field('description', 'string', required=True, notnull=True, length=75), > format = '%(description)s') > > db.define_table('colour_type', > Field('description', 'string', required=True, notnull=True, length=75), > format = '%(description)s') > > > db.define_table('search_form', > Field('pet_type_ref', 'reference pet_type', label='Pet'), > Field('colour_type_ref', 'reference colour_type', label='Pet colour')) > > In index controller: > form = SQLFORM(db.search_form) > return dict(form=form) > > In the view: > {{=form}} > > > In the admin section, I add some pets into the pet_type table but not in > alphabetical order, e.g. Dog, Budgie, Cat > > All works brilliantly in the view with <select> controls being used for > the reference fields. > > However I can't see a way of changing the ordering of the pets for the > select. Currently it defaults to pet_type.description ASC but how would I > change it to the pet_type.id so that the records are displayed in the > order they are inserted? > > Thanks for any advice > Mark > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.