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.
