{"data":[],"metaData":[{"name":"INBOX_DATE"},{"name":"USER_NAME"},{"name":"PATENT_ID"},{"name":"MESSAGE"},{"name":"IS_READ"},{"name":"IS_OFFIDOC"},{"name":"IS_READ_DATE"},{"name":"PROC_TYP"},{"name":"PROC_NBR"},{"name":"ACTION_NBR"},{"name":"INBOX_USER_ID"},{"name":"ACTION_TYPE_NAME"},{"name":"PRIORSTATUS"},{"name":"NEWSTATUS"}],"err":"","query":"\n        SELECT a.INBOX_DATE, b.USER_NAME, a.PATENT_ID, a.MESSAGE, a.IS_READ,\n        a.IS_OFFIDOC, a.IS_READ_DATE, a.PROC_TYP, a.PROC_NBR, a.ACTION_NBR,\n        a.INBOX_USER_ID, d.action_type_name, e.status_name as priorStatus, f.status_name as newStatus\n        FROM SAKI_CF.IP_INBOX a\n        left JOIN SAKI.ip_USER b\n            ON a.INBOX_USER_ID = b.USER_ID\n        left JOIN SAKI.ip_action c\n            ON a.proc_nbr = c.proc_nbr\n            AND a.action_nbr = c.action_nbr\n            AND a.proc_typ = c.proc_typ\n        left join SAKI_CF.cf_action_type d\n            ON c.action_typ = d.action_typ\n        left join SAKI_CF.cf_status e\n            ON c.prior_status_code = e.status_code\n        left join SAKI_CF.cf_status f\n            ON c.new_status_code = f.status_code\n        WHERE INBOX_USER_ID = 31912\n        AND IS_OFFIDOC = 'Y'\n        \n        ORDER BY INBOX_DATE\n        DESC\n    "}