mapper_bs-msg-notice_sql__biz.dim.json

{
  "rules": {},
  "responseField": {},
  "columns": {
    "typeId": {
      "title": "消息类别",
      "isSearch": true,
      "filter": {
        "method": "eq"
      },
      "editPropertie": {
        "showMethodOut": "kv"
      },
      "pagePropertie": {
        "showMethodOut": "kv"
      },
      //控制替换继承列名 _fromPrimaryIds   替换为
      "dimSqlRep": [
        {
          "key": "_fromPrimaryIds",
          "value": "_filterDimTypeId",
          "name": "typeId",
          "alias": "type_id"
        }
      ],

      "dimJoin": {
        "fromDimField": "msgType"
        //"fromDimField": "sysEnum",
        //"allFilter": "parent_id==9"
      }
    }
  },
  "dimDatas": {
    // #region  维数据
    "msgType": {
      "dataFromType": "Database",
      "dimCacheKey": "dim-bs-msg-type",
      "allSql": "select type_name name,'0' parent_id,type_id id,type_id value from mall_commodity_type where is_enabled=1 and type_id in @_fromPrimaryIds order by sort_id asc",
      "name": "消息类别"
    }
    // #endregion  维数据
  }
}