'Custom rows lookup
@param key: the key Field
@param values: the values
@param fields: unused (retained for API compatibility)'

def lookup_rows(self, key, values, fields=[]):

    s3db = current.s3db
    table = self.table
    ptable = s3db.pr_person
    dtable = s3db.disease_disease
    left = [ptable.on((ptable.id == table.person_id)), dtable.on((dtable.id == table.disease_id))]
    if (len(values) == 1):
        query = (key == values[0])
    else:
        query = key.belongs(values)
    rows = current.db(query).select(table.id, table.case_number, dtable.name, dtable.short_name, dtable.acronym, ptable.first_name, ptable.last_name, left=left)
    self.queries += 1
    return rows
