light-apiengine-feature/sqlconfig/system_controller/system_find_org_page_select.tpl

select
    *
from
    sys_org
where
    del_flag = 0
{{if ne .name ""}}
    and name like '%{{.name}}%'
{{end}}
{{if ne .code ""}}
    and code like '%{{.code}}%'
{{end}}
{{if ne .cn_id ""}}
    and inheritance like '%{{.cn_id}}%'
{{end}}
LIMIT {{.rows}} OFFSET {{.offset}}