上级维数就没有转换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