idea中，如何格式化xml中的sql，用reformat code只能格式化标签，对code不起作用

Question

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace跟接口绑定-->
<mapper namespace="com.sunyard.monitor.dao.FlowMapper">
    <select id="queryFlowNum" resultType="com.sunyard.monitor.domain.Flow">
   select * from(select count(1) as flowNum from ccform_debit_all where cf_acctime > to_char(sysdate,'yyyy-MM-dd'))cross join(select count(1) as flowNumMonth from ccform_debit_all where cf_acctime > to_char(sysdate,'yyyy-MM')) cross join (select count(1) as flowNumTotal from ccform_debit_all where cf_acctime > to_char(sysdate,'yyyy'))
  </select>
</mapper>

Answer 1

格式化后是这样的