81,092
社区成员
发帖
与我相关
我的任务
分享
<select id="getTraceListByTime" resultMap="traceMap" statementType="STATEMENT">
select MOND_ID,INTERFACE_CODE,count(*) as REQUEST_COUNT, count( CASE WHEN ERRSTR is not null THEN 1 ELSE NULL END ) as FAILURE_COUNT
from ${table_name} where 1=1
and INTERFACE_CODE!='Svc_ProvisionRet'
and CREATE_DATE>= #{startTime,jdbcType=VARCHAR}
<![CDATA[ and CREATE_DATE< #{endTime,jdbcType=VARCHAR} ]]>
group by MOND_ID,INTERFACE_CODE
order by MOND_ID asc
</select>
List<EsbTrace> getTraceListByTime(@Param("table_name") String table_name,
@Param("startTime") String startTime,@Param("endTime") String endTime);