'Provide the options for the Project search filter
- all Projects with Tasks'

@staticmethod
def project_task_project_opts():

    db = current.db
    ptable = db.project_project
    ttable = db.project_task
    ltable = db.project_task_project
    query = (((ttable.deleted != True) & (ltable.task_id == ttable.id)) & (ltable.project_id == ptable.id))
    rows = db(query).select(ptable.id, ptable.name)
    return dict(((row.id, row.name) for row in rows))
