htmlsql_select_page field is filtered problem

[yejunhong]

htmlsql_select_page!(project_version_select_page(project_code: &str) -> ProjectVersionSelectPageDTO => r#"
SELECT count(1) FROM project_version WHERE is_delete = 0 AND project_code = #{project_code} pv.id, pv.remarks, p.project_code, p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} LIMIT ${page_no},${page_size} `
"#);

create_at 被过滤
试了几次，调整了字段循序，最后一个字段会被过滤

[zhuxiujia]

htmlsql_select_page!(project_version_select_page(project_code: &str) -> ProjectVersionSelectPageDTO => r#" SELECT count(1) FROM project_version WHERE is_delete = 0 AND project_code = #{project_code} pv.id, pv.remarks, p.project_code, p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} LIMIT ${page_no},${page_size} ` "#);

create_at 被过滤 试了几次，调整了字段循序，最后一个字段会被过滤

你应该调整代码为

htmlsql_select_page!(project_version_select_page(project_code: &str) -> ProjectVersionSelectPageDTO => r#"
<select id="project_version_select_page">
`select `
<if test="do_count == true">
 ` count(1) `
 </if>
 <if test="do_count == false">
  ` * `
 </if>
 `FROM project_version WHERE is_delete = 0 AND project_code = #{project_code} pv.id, pv.remarks, p.project_code, p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} `
<if test="do_count == false">
` LIMIT ${page_no},${page_size} `
</if>
 </select>
"#);

[yejunhong]

htmlsql_select_page!(project_version_select_page(project_code: &str) -> ProjectVersionSelectPageDTO => r#" SELECT count(1) FROM project_version WHERE is_delete = 0 AND project_code = #{project_code} pv.id, pv.remarks, p.project_code, p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} LIMIT ${page_no},${page_size} ` "#);
create_at 被过滤 试了几次，调整了字段循序，最后一个字段会被过滤

你应该调整代码为

htmlsql_select_page!(project_version_select_page(project_code: &str) -> ProjectVersionSelectPageDTO => r#"
<select id="project_version_select_page">
`select `
<if test="do_count == true">
 ` count(1) `
 </if>
 <if test="do_count == false">
  ` * `
 </if>
 `FROM project_version WHERE is_delete = 0 AND project_code = #{project_code} pv.id, pv.remarks, p.project_code, p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} `
<if test="do_count == false">
` LIMIT ${page_no},${page_size} `
</if>
 </select>
"#);

跟写法没关系
<select id="select_page_data">SELECT<if test="do_count == true"> count(1) </if> <if test="do_count == false"> pv.id, pv.remarks, p.project_code,p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at, 1 </if> FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} <if test="do_count == false">LIMIT ${page_no},${page_size} </if> </select> 我在字段后面增加 1 ，create_at 字段有返回值，如果不加create_at返回的是空值