Not sure but this is a problem I see db.testcase_test.testtypeids.requires = IS_IN_DB(testtypes, 'testtype.id', 'testtype.name',multiple=True)
implies db.testcase_test.testtypeids stored the texttype.id therefore it should be of type reference to db.testtype and not type 'string' On May 25, 4:47 pm, ggivler <[email protected]> wrote: > I am using the multiselect plugin read and save data from a > crud.create or crude.update form and it just is not working, it seems > to see that there are values there as the field is filled with a "|" > for each option selected. I am not sure what is happening and what I > am doing wrong. Any help would be appreciated. > If I manually fill data into the database and load it using > crud.update(db.testcase_test, testcase_id) it selects the correct > options. I am sure I am missing something stupid and anyone who wants > to point it out would be greatly appreciated. > > Here is the database table > > db.define_table('testtype', > Field('name', 'string', length=45), > Field('description', 'text'), > Field('recordvalid', 'boolean'), > migrate=False) > > db.define_table('testcase_test', > Field('structure', 'string', length=1024,writable=False), > Field('name', 'string', length=255), > Field('description', 'text', length=255), > Field('testmodeid', db.testmode, > requires=IS_IN_DB(db,'testmode.id','testmode.name')), > Field('testtoolid', db.testtool, > requires=IS_IN_DB(db,'testtool.id','testtool.name')), > Field('inputconfigblobid', db.inputblob, > requires=IS_IN_DB(db,'inputblob.id', 'inputblib.localfilename')), > Field('requirementsid', db.requirements, > requires=IS_IN_DB(db,'requirements.id','requirements.name')), > Field('productid',writable=True), > Field('environmentid',writable=True), > Field('commandline', 'string', length=255), > Field('resulttypeid', db.resultstype, > requires=IS_IN_DB(db,'resultstype.id', 'resultstype.resulttype')), > Field('resultunitsid', db.resultunits, > requires=IS_IN_DB(db,'resultunits.id', 'resultunits.unit')), > Field('lowlimit', 'string', length=255), > Field('highlimit', 'string', length=255), > Field('estexectime', 'time'), > Field('lastexectime', 'time', writable=False), > Field('priority','integer',default=-1), > Field('default_priority', 'integer', default=-1), > Field('seqnum', 'integer',default=-1), > Field('testtypeids', 'string'), > migrate=True) > db.testcase_test.structure.label = 'Test Stuite Structure' > db.testcase_test.testmodeid.label = 'Test Mode' > db.testcase_test.testtoolid.label = 'Test Tool' > db.testcase_test.inputconfigblobid.label = 'Test Case Input Config > File' > db.testcase_test.requirementsid.label = 'Test Case Requirements' > db.testcase_test.productid.label = 'Product' > db.testcase_test.commandline.label = 'Test Case Commandline' > db.testcase_test.resulttypeid.label = 'Result Type' > db.testcase_test.resultunitsid.label = 'Result Units' > db.testcase_test.lowlimit.label = 'Low Limit' > db.testcase_test.highlimit.label = 'High Limit' > db.testcase_test.estexectime.label = 'Estimated Execution Time' > db.testcase_test.lastexectime.label = 'Last Execution Time' > db.testcase_test.seqnum.label = 'Sequence Number' > db.testcase_test.testtypeids.label = 'Test Types' > products = db(db.testsuite.parentid==-1) > db.testcase_test.productid.requires = IS_IN_DB(products, > 'testsuite.id', 'testsuite.name') > environments = db(db.testenvironment.recordvalid=='T') > db.testcase_test.environmentid.requires = IS_IN_DB(environments, > 'testenvironment.id', 'testenvironment.name') > testtypes = db(db.testtype.recordvalid=='T') > db.testcase_test.testtypeids.requires = IS_IN_DB(testtypes, > 'testtype.id', 'testtype.name',multiple=True) > > Here is the form code: > def test_case(): > form = None > db.testcase_test.structure.default = > session.testsuite_testsuitestructure > db.testcase_test.productid.default = session.testsuite_productid > for row in > db(db.testenvironment.name==session.testsuite_environmentname).select(): > db.testcase_test.environmentid.default = row.id > #script = SCRIPT("$(document).ready(function() {$ > ('#testcase_test_testtypeids').multiSelect();} > );",_language="javascript",_charset="utf-8") > if len(request.args) > 0: > if request.args[0] == 'edit': > testcase_mode = request.args[0] > testcase_id = request.args[1] > form = crud.update(db.testcase_test,testcase_id) > else: > form = crud.create(db.testcase_test) > > return dict(form=form,session=session) > > Here is the view code: > {{extend 'layout.html'}} > <h1>Test Case</h1> > {{=form}} > {{=plugin_multiselect(db.testcase_test.testtypeids)}} > <h2>Submitted variables</h2> > {{=BEAUTIFY(request.vars)}} > > <h2>Session variables</h2> > {{=BEAUTIFY(session)}}
