logSupplementResultQuery32补录数据查询latestpubliclogsSupplementResultQueryTEAMjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-12-02 17:01:27:8462024-12-02 17:01:27:8461_publicSupplementResultQuery32001 select sbi.taskbussinessid as taskbussinessid, sbi.term as term, sbi.taskCode as taskCode, isb.tmpname as taskCodeName, rist.tmpCode , case when tb.tmpName is null then sn.nounname else tb.tmpName end as tmpCodeName, sbd.tmpRemark , sbi.taskStartDate , sbi.taskOrgcode , so.orgName as taskOrgcodeName, sbi.taskFirstPerson , suf.cnname as taskFirstPersonName , sbi.taskReviewedPerson , sur.cnname as taskReviewedPersonName , risbf.flowbussinessid ,case when tb.tmpName is null then 1 else 0 end as isIndex from rmc_imput_suptaskrun_bussinessinfo sbi left join rmc_imput_suptaskrun_tmprelas rist on sbi.taskbussinessid = rist.taskbussinessid left join rmc_imput_suptaskrun_bussinessdetail sbd on sbi.taskbussinessid = sbd.taskbussinessid and sbi.taskCode = sbd.taskCode and rist.tmpCode = sbd.tmpCode left join rmc_imput_tmpconf_baseinfo tb on rist.tmpCode = tb.tmpcode left join sys_noun sn on sn.nounitem = 'TMP-INDEX-NOUN' and sn.nounvalue = rist.tmpcode left join rmc_imput_suptaskconf_baseinfo isb on isb.taskCode = sbi.taskCode left join sys_user suf on sbi.taskFirstPerson = suf.ACCOUNT left join sys_user sur on sbi.taskReviewedPerson = sur.ACCOUNT left join sys_organization so on sbi.taskOrgcode = so.ORGCODE left join rmc_imput_suptaskrun_bussinessflowinfo risbf on sbi.taskbussinessid = risbf.taskbussinessid where 1=1 and sbi.taskStatus = '04' and sbi.term = #{termParam} and rist.tmpCode in ( ${tmpCodesParam} ) AND risb.taskOrgcode in (${_datascopeorg) AND sbi.taskReviewedPerson = #{_datascopeaccount} AND suf.orgcode in (${_datascopeorg) order by sbi.taskbussinessid desc, sbi.term desc , sbi.taskStartDate desc ]]>logsSupplementResultQueryTEAM1补录数据查询功能逻辑组latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04jdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster04adminadmin2024-10-13 11:07:54:9312024-10-13 11:07:54:931补录数据查询逻辑组_publiclogSupplementResultQuery32SupplementResultQueryTEAM190SupplementResultQueryTEAM1SupplementResultQuery01RstSetSupplementResultQuery]]>rdpTaskInfoViewShowExcel2补录信息查看latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbqian_jweiqian_jwei2024-10-22 12:50:04:3632024-10-22 12:50:04:3631_publicanamode查看模式1flowbussinessid补录流程实例1nulltaskCode补录任务编号1nulltaskCodeNametaskCodeName1nulltaskFirstPerson补录人ID1nulltaskFirstPersonName补录人名称1nulltaskOrgcode补录机构编号ID1nulltaskOrgcodeName补录机构1nulltaskbussinessid补录任务实例，业务流程实例号1nullterm数据期次1nulltmpCode补录模板编号1nulltmpCodeName补录模板名称1nullTaskInfoViewShowExcel2coding>0]]>rdpTaskInfoViewShowIndex1页面指标补录查看功能latestpublic_PUBLIC_PUBLIC10.1.80.882883rmcdb10.1.80.882883rmcdbli_gpuli_gpu2024-11-01 15:39:55:5792024-11-01 15:39:55:579增加页面指标查看功能_publicflowbussinessid流程实例1nulltaskbussinessid补录任务编号1nullTaskInfoViewShowIndex1coding>0]]>rdpSupplementResultQuery29补录数据查询latestpublic_PUBLIC_PUBLICjdbcoceanbase10.1.80.882883rmcdbrmcdata@BQD_RMC#bqd_obcluster0410.1.80.882883rmcdbadminadmin2024-12-02 16:50:30:3032024-12-02 16:50:30:3031_publiclogsSupplementResultQueryTEAM1rdpTaskInfoViewShowExcel2rdpTaskInfoViewShowIndex1SupplementResultQuery29querySupplementResultQueryTEAM0>0logs]]>