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

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