上级维数就没有转换KV ,添加dimJoin

{
  "rules": {},
  "responseField": {},
  "columns": {
    "parentId": {
      "editPropertie": {
        "showMethodOut": "kv"
      },
      "addPropertie": {
        "showMethodOut": "kv"
      },
      "pagePropertie": {
        "showMethodOut": "kv"
      },
      "dimJoin": {
        "fromDimField": "parentId"
      }
    }
  },
  "dimDatas": {
    "parentId": {
      "allSql": "select tb_d.router_name name,tb_d.router_id id,parent_id,tb_d.router_id value from activity_router_link tb_d where {s-if:_fromPrimaryIds} router_id in @_fromPrimaryIds {e-if:_fromPrimaryIds}",
      "connName": "ConnAct",
      "dataFromType": "Database",
      "name": "上级路由",
      "dimCacheKey": "dim-activity-router-link-parent-id"
    }
  }
}

"parentId": {
      "fieldSort": 9999,
      "tableId": 1,
      "dataType": "varchar",
      "title": "上级栏目",
      "guidMethod": "None",
      "isRequired": false,
      "isSearch": true,
      "isData": true,
      "dimJoin": {
        "fromDimField": "parentId",
        "allFilter": "",
        "joinChar": ","
      },
      "filter": {
        //通过迭代方式进行过滤
        "isMust": false,
        "method": "iteration",
        "sql": " and menu_id in @parentId",
        "tableName": "bo_sys_menu",
        "whereSql": " ",
        "iterationId": "menu_id",
        "iterationParentId": "parent_id",
        "dbRead": null
      },
      "field": "parentId",
      "name": "parent_id",
      "alias": "parent_id",
      "editPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "addPropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "pagePropertie": {
        "showMethodOut": "kv",
        "showMethod": "text",
        "type": null,
        "format": null,
        "defaultValue": null
      },
      "isDate": false,
      "isPrimary": false,
      "isIdentity": false,
      "maxLength": 100,
      "colDecimal": 0
    },
文档更新时间: 2022-06-13 09:20   作者:admin