I tried: db.mentors.auth_user_id.requires = IS_IN_DB(db, 'auth_user.id', '%(name)s', orderby = db.auth_user.first_name) but it had no effect. I read on another question about building and ordering a set and then using IS_IN_SET on that but I'm not sure how to go about doing that; can I do a query right below my mentor table definition in the model? Sorry for being such a noob.
On Wednesday, December 16, 2015 at 12:48:10 PM UTC-7, Niphlod wrote: > > a proper IS_IN_DB with the correct orderby in models should be the easiest > way to go. > > On Wednesday, December 16, 2015 at 8:33:06 PM UTC+1, Evan Caldwell wrote: >> >> >> I am having a hard time ordering a dropdown in a SQLFORM alphabetically. >> >> In my model: >> db.define_table('departments', >> Field('name', notnull=True, unique=True), >> Field('college_id','reference college', label='College'), >> Field('department_rep_user_id','reference auth_user', >> label='Department Representative'), >> auth.signature, >> format='%(name)s') >> >> db.define_table('mentors', >> Field('auth_user_id', 'reference auth_user', unique=True), >> Field('department_id', 'reference departments', label='Department'), >> auth.signature, >> format=repr_mentor_table) >> >> db.define_table('abstracts', >> Field('title', notnull=True, unique=True), >> Field('college_id', 'reference college', label='College'), >> Field('department_id', 'reference departments', label='Abstract >> Department'), >> Field('mentor_id', 'reference mentors', label='Mentor'), >> Field('classes_id', 'reference classes', label='Class', comment="If >> your abstract is connected to a specific class (perhaps as a class >> project), select your class. Otherwise, select 'Does not apply'"), >> Field('session_id', 'reference sessions', label='Session'), >> Field('presentation_format_id', 'reference presentation_formats', >> label='Presentation Format'), >> Field('body','text'), >> Field('attatchment', 'upload'), >> Field('location_id', 'reference locations', label='Location'), >> Field('conference_id', 'reference conferences', label='Conference'), >> Field('presentation_time', 'time', notnull=False, requires=IS_TIME(), >> label='Presentation Time'), >> Field('booth_space', label='Booth Space'), >> Field('initial_approval', 'boolean', label='Initial Approval', >> default=None), >> Field('final_approval', 'boolean', label='Final Approval', >> default=None), >> Field('competing_status', 'boolean', label='Competing Status', >> default=None), >> auth.signature, >> format='%(title)s', >> singular="Abstract", >> plural="Abstracts", >> ) >> >> In the controller >> def abstracts(): >> response.title = "Abstracts" >> >> def get_primary_author(abstract_row): >> author_row = db( >> (db.abstract_author.primary_author==True) & >> (db.abstract_author.abstract_id==abstract_row.id) & >> (db.abstract_author.auth_user_id==db.auth_user.id) >> ).select( >> db.auth_user.first_name, >> db.auth_user.last_name).first() >> return author_row.first_name + ' ' + author_row.last_name >> >> def abstracts_body_represent(body, row): >> sanitized = str(rcwc_sanitizer(body)) >> >> # This is really fragile. For some reason the grid isn't enforcing >> # maxtextlength if the represent is called. >> if len(request.args) == 1: # not on the grid page >> sanitized = "{0}...".format(sanitized[:100]) >> return XML(sanitized) # If this returns a string it isn't used >> >> db.abstracts.body.represent = abstracts_body_represent >> >> grid = SQLFORM.smartgrid( >> db.abstracts, >> user_signature=False, >> searchable=True, >> linked_tables=['abstract_author'], >> links=[ >> {"header": "Primary Author", "body":get_primary_author}, >> ], >> links_placement="left", >> paginate=75, >> ) >> >> return locals() >> >> When I go to create a new abstract in the abstracts table the dropdown >> for Mentors (mentor_id field) is not alphabetically ordered. Can this be >> accomplished in the model or would I need to work it out in the controller? >> >> -- 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.