Page tree
Skip to end of metadata
Go to start of metadata

第一步,数据库连接定义

Resource建立Database connection  连接

第二步,新建自定义字段

类型为:Database picker



Validation SQL

select id,NAME from ao_60db71_sprint

where CLOSED = false and id = ?

Search Sql

select id,NAME from ao_60db71_sprint

where CLOSED = false and lower(name) like concat(lower(?), '%')


注意

定义的字段如果已经使用,特别是第三方插件被引用,禁止删除







  • No labels