跳到主内容
1月16日是美国的假日,我们将提供有限的支持,敬请谅解。

社区

搜索

欢迎来到社区

Query to get all bridge errors

评论

1 条评论

  • Michael Pay

    Hi Avinash,

    You might be able to do something like

    SELECT
                    job_id,
                    "address.errors",
                    "hco.errors",
                    "hcp.errors",
                    "license.errors",
                    "parenthco.errors"    
        FROM
                    job_stats_summary
        ORDER BY
            job_id DESC LIMIT 100

    In order to get your last 100 jobs and skim through whether they have errors or not.

    Or if you remember the last job you checked, you might be able to do WHERE job_id > {your last job id}

    I tried using more complicated queries that joins the job table or do a where clause on the ".error" fields but those all failed to compile / build execution plan / validate.

    This query also takes a very long time to run and I'm not sure why, maybe you could open a support ticket on this to have it investigated.

     

    Hope this helps,

    Michael

    0

请先登录再写评论。

由 Zendesk 提供技术支持