注意 “method”: “custom”
// #region 查找带回
"rightProductId": {
"fieldSort": 9999,
"tableId": 1,
"dataType": "varchar",
"title": "右侧工厂",
"remark": "用于搜索",
"guidMethod": "None",
"isRequired": false,
"isSearch": true,
"isData": false,
"editPropertie": {
"showMethod": "text"
},
"pagePropertie": {
"showMethod": "text"
},
"filter": {
"method": "custom",
"isMust": false,
//"sql": " and parent_id in (select menu_id from bo_sys_menu where menu_name like CONCAT('%',@parentName,'%'))",
//如果 sqlCustom 没找到,使用 sql sqlserver mysql oracle sqlite SqlCustom
"sql": " and product_id<>@rightProductId",
"sqlCustom": {
"mysql": " and product_id<>@rightProductId",
"oracle": "",
"sqlserver": ""
}
},
"field": "rightProductId",
"name": "right_product_id",
"alias": "right_product_id",
"isDate": false,
"isPrimary": false,
"isIdentity": false,
"maxLength": 50
}
// #endregion 查找带回
文档更新时间: 2022-05-31 16:32 作者:admin