opt: 人大金仓数据库改造

linwei

2026-04-08 a21190df18e72716197c731111dc9d848c2d05a9

opt: 人大金仓数据库改造

 drone-service/drone-gd/src/main/java/org/sxkj/gd/orderdata/mapper/GdDataObjectionMapper.xml

@@ -84,21 +84,22 @@
    </select>

    <select id="getDetail" resultType="org.sxkj.gd.orderdata.vo.GdDataObjectionVO">
        select
            obj.*,
        string_agg(da.attach_name SEPARATOR ',') as attach_names ,
        string_agg(da.attach_id SEPARATOR ',') as attach_ids
        from
            ja_gd_data_objection obj
        left join
                ja_gd_data_objection_attachment da on obj.id::VARCHAR = da.objection_id::VARCHAR
        SELECT
        obj.*,
        string_agg(da.attach_name::text, ',') AS attach_names,
        string_agg(da.attach_id::text, ',') AS attach_ids
        FROM
        ja_gd_data_objection obj
        LEFT JOIN
        ja_gd_data_objection_attachment da ON obj.id::text = da.objection_id::text
        <where>
                and da.is_deleted = 0
            <if test="id != null ">
                and obj.id = #{id}
            da.is_deleted = 0
            <if test="id != null">
                AND obj.id::text = #{id}::text
            </if>
        </where>
        group by obj.id
        GROUP BY
        obj.id
    </select>

</mapper>