<!--根据数据集组id获取分享组的数据--><selectid="querySharedGroupIds"resultType="com.pactera.magic.entity.DataBaseInfo">
SELECT DISTINCT
b.*
FROM
magicdb_base.bs_adm_data_group AS g
LEFT JOIN magicdb_data.dt_data_grp_info i ON g.business_belong_id = i.id
AND i.is_dtl = '0'
LEFT JOIN magicdb_data.dt_data_base_info b ON b.id = g.business_id
AND b.is_dtl = '0'
<where>
g.is_dtl = '0'
<iftest="groupDataInfoVo.datagrpId!=null and groupDataInfoVo.datagrpId!=''">
AND g.business_belong_id = #{groupDataInfoVo.datagrpId}
</if><iftest="groupDataInfoVo.dataStatus!=null and groupDataInfoVo.dataStatus!=''">
AND b.data_status= #{groupDataInfoVo.dataStatus}
</if><iftest="groupDataInfoVo.dataName!=null and groupDataInfoVo.dataName!=''">
AND b.data_name like concat('%',#{groupDataInfoVo.dataName},'%')
</if><iftest="groupDataInfoVo.dataType!=null and groupDataInfoVo.dataType!=''">
AND b.data_type = #{groupDataInfoVo.dataType}
</if><iftest="groupDataInfoVo.startDate!=null and groupDataInfoVo.startDate!=''">
and b.created >=DATE_FORMAT(#{groupDataInfoVo.startDate},'%Y-%m-%d 00:00:00')
</if><iftest="groupDataInfoVo.endDate!=null and groupDataInfoVo.endDate!=''">
AND b.created <![CDATA[ <= ]]>DATE_FORMAT(#{groupDataInfoVo.endDate},'%Y-%m-%d 23:59:59')
</if>
ORDER BY created DESC
</where></select>