Ok, now I understand... You should allways use id instead of name or other field. Anyway I think you can figure it out from this example :
dog name person_id person name stat_about_dog_and_person stat1 stat2 dog_name person_name If I want to get dog_name or person_name in stat_about_dog_and_person.dog_name I could something like this : db.dog(ID).name You just have to replace the ID by the id or a query that return the id... You can even do : db.dog(db.auth_user(db.ham(ID).id)).id).name Richard On Mon, May 7, 2012 at 5:09 PM, Jim Steil <[email protected]> wrote: > Sorry, not sure I follow. > > In my example, helpdeskTech is a subset of auth_user. My 'ticket' has a > helpdeskTechId (in the assignedTo field), not an id from the auth_user > table. I want my select tag to display the auth_user name, but return the > helpdeskTechId from the helpdeskTech table. > > Maybe I don't fully grok the IS_IN_DB and the way the parms work. I'll go > back and look that over again. > > -Jim > > > On 5/7/2012 3:59 PM, Richard Vézina wrote: > > auth_user_rows = db().select(db.auth_user.id) > > make a set : > > auth_user_set = ((db.auth_user.id == rows.first().id)|(db.auth_user.id== > rows.last().id)) > > IS_IN_DB(auth_user_set,...) > > Richard > > On Mon, May 7, 2012 at 4:37 PM, Jim Steil <[email protected]> wrote: > >> 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 >> >> >> >> >
