No at the database level because the database does sorting (this is important to be able to scale). you can use Field(...,writable=False, compute=....)
On Sep 7, 11:41 am, Richard Vézina <[email protected]> wrote: > Does that extra field has to be create a the database level or just at the > web2py model level? Is virtual field for that purpose? > > Richard > > 2010/9/7 mdipierro <[email protected]> > > > everything looks right to me except for orderby=(_format') You must > > orderby a field. If the _format is more complex than a single field I > > suggest you give an extra field to ref_fnaregistry that is > > automatically computed and stores the format. > > > On Sep 7, 11:26 am, Richard Vézina <[email protected]> > > wrote: > > > Hello Massimo, > > > > Is there a way to do something like this : > > > > db.ref_vregistry.fnaregistry_id.requires = > > > IS_IN_DB(db,'ref_fnaregistry.fnaregistry_id',db.ref_fnaregistry._format,orderby=('_format')) > > > > ? > > > > Richard
