第一步,数据库连接定义
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(?), '%') |
注意
定义的字段如果已经使用,特别是第三方插件被引用,禁止删除