|
|
写SQL实现, 看在哪需要就写在哪
可查看下面脚本示例:
(function(){
var doc = getCurrentDocument();//获取查询头doc对象
var PurchaseOrderNumber = doc.getItemValueAsString("PurchaseOrderNumber")//获取查询头对应字段的值
var sql="select domainid,id,formid,item_PurchaseOrderNumber from tlk_Number where 1=1";
if(PurchaseOrderNumber!="" && PurchaseOrderNumber != null){
sql+=" and item_PurchaseOrderNumber like '%"+PurchaseOrderNumber+"%'";
}
return sql;
})(); |
|