Are you saying you don't want to sort by the labels at all, but by some field(s) in auth_user that are otherwise not visible to the user? If so, I don't think you'll be able to do that with IS_IN_DB. Instead, build (and order) your set of values and labels manually, and then use the IS_IN_SET validator. Alternatively, you could use the IS_IN_DB validator to do the validation, and then override the "widget" attribute of the field with a custom widget that generates the options as you want them.
Anthony On Saturday, November 21, 2015 at 12:32:13 PM UTC-5, Hilton Shumway wrote: > > I'm building a site with a number of different tables linked to the > auth_user table, namely mentors, judge, etc. A few different tables link > indirectly to auth_user through foreign keys to those tables, for example > abstract has a foreign key to mentor, which has a foreign key to auth_user. > > Now, it's possible the models should have been designed differently, but > considering the site is in production now, changing that is a little > difficult. > > My challenge is that various forms (including create/edit of abstracts, > SQLFORM.grid-based searching of abstracts, etc) provide a select widget > filled with available mentors, which is sorted according to mentor.id. > I'd like to make that sorting alphabetical according to > auth_user.first_name. After a bit of poking around I found > http://stackoverflow.com/questions/28238708/how-to-set-default-orderby-in-a-web2py-table > > (which doesn't seem to be documented in the web2py book), but that would > only allow me to sort the select widget according to fields in mentor. If I > try to pass orderby=db.auth_user.first_name to IS_IN_DB, I get a <class > 'sqlite3.OperationalError'> no such column: auth_user.first_name error. > > Am I missing something obvious? My guess is that when IS_IN_DB makes its > query it doesn't select anything from auth_user, and attempts to reference > those columns don't work. Is there a way to change this? > > I'm happy to provide more information if needed. > > Hilton > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
