I have the following models. I am storing memos in table *memo_store*, and
user_views in *viewed_memos*. Each user can have multiple views for each
memo. Every time they look at a memo, I store a new entry in* viewed_memos*.
My question is: *How can I construct a query which will display all unread
memos from a particular user?*
I was hoping to do it in a single-step query, however, I am struggling.
*Table Definitions:*
db.define_table ('memo_store',
Field ('created_by', db.auth_user, default = auth.user_id, readable =
False, writable = False),
Field ('created_on', 'datetime', default = request.now, writable =
False, readable = False),
Field ('memo', 'upload', uploadfolder = os.path.join (request.folder,
'memo_uploads'),
ondelete = 'NO ACTION', uploadseparate = True,),
Field ('file_name', 'string', readable = False, writable = False),
Field ('author', 'string'),
Field ('department', 'string', requires = IS_IN_SET (department_list)),
Field ('memo_title', 'string'),
Field ('memo_note', 'text'),
Field ('tags', 'list: string'),
)
db.define_table ('viewed_memos',
Field ('created_by', db.auth_user, default = auth.user_id, readable =
False, writable = False),
Field ('created_on', 'datetime', default = request.now, writable =
False, readable = False),
Field ('memo', db.memo_store),
Field ('my_tags', 'list: string'),
)
