-- Code generated by dol build. Only Generate by tools if not existed. -- 1. You must specify the appropriate field name, instead of the *, field can be referenced in sql/sqlmap/.xml. -- 2. You must load user information from the code level if you need, because the user information is present in another table. select article.id from article where article.id {{.ne}} "" and article.del_flag {{.ne}} 1 {{if ne .role_rule ""}} and {{.role_rule}} {{end}} LIMIT {{.size}} OFFSET {{.offset}}