From b9b031348b72b9997f44f790a613dcf00766fae0 Mon Sep 17 00:00:00 2001 From: yuxc <653031404@qq.com> Date: 星期一, 19 六月 2023 17:53:00 +0800 Subject: [PATCH] 1、查询返回的数据类型错误。 --- Source/UBCS/ubcs-service/ubcs-code/src/main/resources/mapper/CodeClassifyTemplateMapper.xml | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/Source/UBCS/ubcs-service/ubcs-code/src/main/resources/mapper/CodeClassifyTemplateMapper.xml b/Source/UBCS/ubcs-service/ubcs-code/src/main/resources/mapper/CodeClassifyTemplateMapper.xml index ff8c8b0..2518fb3 100644 --- a/Source/UBCS/ubcs-service/ubcs-code/src/main/resources/mapper/CodeClassifyTemplateMapper.xml +++ b/Source/UBCS/ubcs-service/ubcs-code/src/main/resources/mapper/CodeClassifyTemplateMapper.xml @@ -100,11 +100,11 @@ - <select id="selectChildHasReleaseTemplate" resultType="list"> + <select id="selectChildHasReleaseTemplate" resultType="map"> select t.oid as oid, cls.oid as clsoid - from platformbtm_codeclstemplate t + from pl_code_clstemplate t left join (select oid - from platformbtm_codeclassify + from pl_code_classify where lcstatus = #{lcstatus} start with oid = #{classifyoid} connect by prior oid = parentcodeclassifyoid) cls -- Gitblit v1.9.3