How can we do the following ?
1. Use two fields value for the label name
db.TDMUSJ00.TRTRKN works fine but I want to do like db.TDMUSJ00.TRTRKN +
"(" + db.TDMUSJ00.TRTRCD + ")" as label name.
2. Look up the data whether it's small or capital letter
Value in the database (db.TDMUSJ00.TRTRKN) is all capital and autocomplete
doesn't look up the data when user type by small letters.
Table 1
--------------------------------------------------------------------------------------------
db.define_table('TDMUSJ00',
Field('TRTRCD', length=8, label="End User Code"),
Field('TRTSCD', length=3, label="Dept"),
Field('TRTRKN', length=30, label="Cust Name"),
primarykey=['TRTRCD'])
--------------------------------------------------------------------------------------------
Table2
--------------------------------------------------------------------------------------------
db.define_table('EDXUSF00',
Field('USDIID', length=5, label="Dist Code"),
Field('USACCT', length=30, label="Dist End User Code"),
Field('USUSCD', length=8, label="End User Code"),
Field('USUPFL', length=1, label="OZ UPLOAD FLAG"),
Field('USCRBY', length=20, default = auth.user.username.upper() if
auth.user else None, label="Created by"),
Field('USCRDT', 'datetime', default =request.now, label="Created on"),
Field('USUPBY', length=20, update = auth.user.username.upper() if
auth.user else None, label="Updated by"),
Field('USUPDT', 'datetime', update =request.now, label="Updated on"),
primarykey=['USDIID', 'USACCT'])
db.EDXUSF00.USDIID.requires=IS_IN_DB(db,db.EDMFVF00.FVTKCD,'%(FVNAME)s
(%(FVTKCD)s)')
db.EDXUSF00.USACCT.requires=[IS_NOT_EMPTY(),IS_LENGTH(30,1),IS_UPPER()]
db.EDXUSF00.USUSCD.requires=[IS_IN_DB(db,db.TDMUSJ00.TRTRCD),IS_UPPER()]
db.EDXUSF00.USUSCD.widget=SQLFORM.widgets.autocomplete(
request, db.TDMUSJ00.TRTRKN+db.TDMUSJ00.TRTRCD,
id_field=db.TDMUSJ00.TRTRCD)
db.EDXUSF00.USUPFL.writable = db.EDXUSF00.USUPFL.readable = False
db.EDXUSF00.USCRBY.writable = False
db.EDXUSF00.USCRDT.writable = False
db.EDXUSF00.USUPBY.writable = False
db.EDXUSF00.USUPDT.writable = False
--------------------------------------------------------------------------------------------
--
