result = [{'value': '', 'text': '全部'}]
try:
    async with get_sor_context(request._run_ns, 'entity') as sor:
        rows = await sor.sqlExe("select k as value, v as text from appcodes_kv where parentid='entity_status' order by k", {})
    return json.dumps(result + [{'value': r.value, 'text': r.text} for r in rows], ensure_ascii=False)
except Exception as e:
    debug('get_search_status error: %s' % str(e))
return json.dumps(result, ensure_ascii=False)