mapper_mall-business_sql__columns.json

{
  "columns": {
    // #region 查找带回
    "rightBusinessId": {
      "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
        "sqlCustom": {
          "mysql": " and business_id<>@rightBusinessId",
          "oracle": "",
          "sqlserver": ""
        }
      },
      "field": "rightBusinessId",
      "name": "right_business_id",
      "alias": "right_business_id",
      "isDate": false,
      "isPrimary": false,
      "isIdentity": false,
      "maxLength": 50
    }
    // #endregion 查找带回
  }
}