Hi
I am having trouble getting my list to display the way I want it to.
Given the following definition:
-----------------------
helpdeskTech = db.define_table('helpdeskTech',
Field('helpdeskTechId', 'id', readable=False),
Field('helpdeskId', db.helpdesk, required=True, label='Helpdesk'),
Field('userId', db.auth_user, required=True, label='User'),
format='%(userId.lastFirst)s')
helpdeskTech.helpdeskId.requires = IS_IN_DB(db, db.helpdesk,
'%(name)s',
zero='...choose...')
helpdeskTech.userId.requires = IS_IN_DB(db, db.auth_user,
'%(lastFirst)s',
zero='...choose...')
helpdeskTech['_plural'] = 'Technicians'
ticket = db.define_table('ticket',
Field('ticketId', 'id', readable=False),
Field('helpdeskId', db.helpdesk, required=True, label='Helpdesk'),
Field('name', length=100, required=True),
Field('description', 'text'),
Field('createdOn', 'date', label='Created'),
Field('createdBy', db.auth_user, required=True, label='Creator'),
Field('assignedTo', db.helpdeskTech, label='Assigned To'),
Field('priority', length=10, required=True),
Field('status', length=10, required=True),
format='%(name)s')
ticket.helpdeskId.requires = IS_IN_DB(db, db.helpdesk,
'%(name)s',
zero='...choose...')
ticket.name.requires = IS_NOT_EMPTY()
ticket.createdOn.requires = IS_DATE('%m/%d/%Y')
ticket.createdBy.requires = IS_IN_DB(db, db.auth_user,
'%(lastFirst)s',
zero='...choose...')
ticket.assignedTo.requires = IS_NULL_OR(IS_IN_DB(db, db.helpdeskTech,
zero='...choose...'))
-----------------------
I want my IS_IN_DB validator in the last line to display the last name
and first name from the auth_user table.
But, what I'm getting is the helpdeskTechId field displaying.
I'm wondering how I can refer back to the auth_user table to get the
names to display in the dropdown instead of the helpdeskTechId without
custom-coding the view.
Thoughts?
-Jim
