修改综治后台报错

lidongdong

2023-07-07 7a8a3ee1665cb2391d5d90304c974ec87fef2533

修改综治后台报错

 springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventGridDataMapper.xml

@@ -45,8 +45,8 @@
        egd.create_at,
        su1.`name` as createBy,
        egd.grid_community_id,
        (select lc_grid_name from lc_compare_code where local_grid_id = egd.id) as lcGirdName,
        (select id from lc_compare_code where local_grid_id = egd.id) as lcGirdId,
        (select lc_grid_name from lc_compare_code where local_grid_id = egd.id  LIMIT 1) as lcGirdName,
        (select id from lc_compare_code where local_grid_id = egd.id  LIMIT 1) as lcGirdId,
        ca.`name` AS communityName
        FROM
        event_grid_data AS egd