智能搜索框属性中选择 服务器动态数据查询(选项脚本通过"_keyword"参数获取输入内容) 并在选项中输入以下脚本。
var param = getParameter("_keyword");
if (param == "" || param.length() <= 0)
param = " ";
var sql = "select name as item_NAME,'"+getDomainid()+"'domainid from obpm_trunk.t_user where LOGINNO LIKE '%" + param + "%' limit 0,5";
var names = queryBySQL(sql);
var rtn = "";
if(names != null || names != ''){
for (var iter = names.iterator(); iter.hasNext();) {
var name = iter.next();
rtn += name.getItemValueAsString("name")+";";
}
}
rtn; |