问题详情
改进
重要
描述
生产查询脚本示例：
SELECT * FROM prpm_case_info WHERE insure_com_branch_code NOT in (
'00000000',
'10000000',
'11000000',
'12000000',
'13000000',
'20000000',
'21000000',
'22000000',
'30000000',
'50000000',
'60000000',
'61000000',
'62000000',
'63000000',
'64000000'
)
AND report_time<'2021-09-26'
以上SQL导致机构编码为00020000的没有统计进去
活动
| 字段 | 原值 | 新值 |
|---|---|---|
| 描述 |
生产查询脚本示例：
SELECT * FROM prpm_case_info WHERE insure_com_branch_code NOT in ( '00000000', '10000000', '11000000', '12000000', '13000000', '20000000', '21000000', '22000000', '30000000', '50000000', '60000000', '61000000', '62000000', '63000000', '64000000' ) AND report_time<'2021-09-26' |
| 描述 |
生产查询脚本示例：
SELECT * FROM prpm_case_info WHERE insure_com_branch_code NOT in ( '00000000', '10000000', '11000000', '12000000', '13000000', '20000000', '21000000', '22000000', '30000000', '50000000', '60000000', '61000000', '62000000', '63000000', '64000000' ) AND report_time<'2021-09-26' |
生产查询脚本示例：
SELECT * FROM prpm_case_info WHERE insure_com_branch_code NOT in ( '00000000', '10000000', '11000000', '12000000', '13000000', '20000000', '21000000', '22000000', '30000000', '50000000', '60000000', '61000000', '62000000', '63000000', '64000000' ) AND report_time<'2021-09-26' 以上SQL导致机构编码为00020000的没有统计进去 |
| 附件 | screenshot-1.png [ 18752 ] |
| 附件 | screenshot-2.png [ 18753 ] |
| 主题 | 【报表-机构案件数量统计】中，深圳分公司的只统计了机构编码为00000000的00020000的，未统计 | 【报表-机构案件数量统计】中，深圳分公司的只统计了机构编码为00000000的，未统计00020000的 |
| issue.field.resolutiondate | 2022-06-14 09:41:53.0 | 2022-06-14 09:41:53.425 |
| 预估剩余时间 | 0 minutes [ 0 ] | |
| 已耗费时间 | 6 seconds [ 6 ] | |
| 工作日志 Id | 15780 [ 15780 ] |
| 状态 | Open [ 1 ] | Closed [ 6 ] |
| 解决结果 | Fixed [ 1 ] | |
| 项目环境 | SIT [ 10001 ] | PRD [ 10003 ] |
生产上线过的需求