自定义Sql

注意 “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 查找带回