left join (Attribute Error)

[F.C.]

I am trying to create a left join query and must be something stupidly wrong as it doesn't work

Any suggestions? Thanks for any help!

db.define_table('procedures',

                Field('id',writable=False, readable=False, label='ID'),

                Field('procedurenumber', unique=True, label='Procedure Number'),

                Field('procedurename', unique=True, label='Procedure Name'),

                Field('proceduredesc', label='Procedure Description'),

                Field('procdomain',label='ITGC Domain'))

db.define_table('requestlist',

                Field('id',writable=False, readable=False, label='ID'),

                Field('requestdesc', label='Request'),

                Field('phaseid', 'reference phase', format = '%(pname)s', label='Phase'),

                Field('proceduresid', 'reference procedures', format = '%(procedurename)s', label='Procedure Name'),

                Field('reqrequestdate', 'date', label='Request Date', widget=SQLFORM.widgets.date.widget),

                Field('reqduedate', 'date', label='Due Date'),

                Field('reqdaysoutstanding', label='Days Outstanding', writable=False),

                Field('reqdateexpected', 'datetime', label='Date Expected'),

                Field('reqdatedelivered', 'datetime', label='Date Delivered'),

                Field('reqstatus', label='Status'),

                Field('assignedto', 'reference poc', format='%(pocname)s', label='Assigned To'),

                Field('reqevidenceloc', label='Evidence Location'),

                Field('reqrequestorid', 'reference poc', format='%(pocname)s', label='Requestor'))

def pbc():

    records = db().select(db.requestlist.ALL, db.procedures.ALL, left=db.procedures.on(db.procedures.id == db.requestlist.proceduresid))

    return dict(records=records)

[Annet]

Hi,

I think it should be:

left=db.requestlist.on(db.procedures.id == db.requestlist.proceduresid)


Regards,

Annet