和 where 元素等价的自定义 trim 元素为:
<trim prefix="WHERE" prefixOverrides="AND |OR "> ... </trim>
having 的 mybatis 实现:
group by a.hospital_code, a.hospital_name, a.provmanager_accode, a.provmanager_name, a.doctor_name, a.department_name, a.positional_name, a.msl_name, a.register_date, a.province_name, a.city_name, a.area_name, a.street_name, a.commitee_name
<trim prefix="having" prefixOverrides="and" >
<if test='minActiveNum != null'>
and acitve_num <![CDATA[ >=]]> #{minActiveNum}
</if>
<if test='maxActiveNum != null'>
and acitve_num <![CDATA[ <=]]> #{maxActiveNum}
</if>
</trim>
order by acitve_num desc, convert(a.doctor_name using gbk) asc
mysql、doris 的中文拼音字母排序实现:
(doris中order by可避免接口的部分页面结果不展示问题)
order by acitve_num desc, convert(a.doctor_name using gbk) asc