'Get project list'

def get_project_list(self, user_id=None):

    if (not user_id):
        user_id = frappe.session.user
    project_list = frappe.db.sql(u"select    *\n DCTB  DCTB  DCTB from    `tabProject`    where    status='Open'    and    project_type='External'\n DCTB  DCTB  DCTB order    by    modified    asc    limit    10", as_dict=True)
    for t in project_list:
        t.link = get_url_to_form(u'Issue', t.name)
    return project_list
