这个是过滤语句,但是效果跟用控件一样,都是报错
var empData = this.comp("mainData");
empData.setFilter("myfilter", " EXISTS (SELECT 1 FROM SA_OPManagement SO JOIN SA_OPManageType ST ON SO.sManageTypeID = ST WHERE "+
" ST.sCode = 'intendsEmployManagement' "+
"AND SO.sOrgID like '"+
this.getContext().getCurrentPersonID() +"%' AND EHR_EP_Employee.fFID like concat(SO.sManageOrgFID,'%'))");