处理链返回成功标识

select a.batchdate "日期",

    a.batchtime "启动时间",

    case a.state

    when 'R' then '报错'

    when 'A' then '执行中'

    when 'G' then '成功'

    when 'X' then '手工取消'

    else '未知' end "执行状态 "

        from  "SAPSR3"."RSPCPROCESSLOG" as a left join "SAPSR3"."RSPCLOGCHAIN" as b

    on a.log_id = b.log_id

    where b.CHAIN_ID='CWJGDSJ_QD1'

    group by a.batchdate,a.state,a.batchtime

    order by a.batchdate desc,a.state desc, a.batchtime asc

    limit 1