Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings
/S2Public

透视表树形行头 怎么展示 单维度树形结构数据#2954

Unanswered
youhan26 asked this question inQ&A
Discussion options

我这边的数据是按照明细表的平铺行数据格式,示意如下:

{id:1,parentId:null,colA:1,colB:2,colC:3,name:'行1'},{id:2,parentId:1,colA:1,colB:2,colC:3,name:'行2'},

因为明细表没有行头,设置不了树形结构,所以只能使用透视表来展示,然后由于数据不是按照单一维度,所以没有办法类似下面配置来展示:

{columns:['colA','colB','colC'],rows:['id']}

这样配置会有两个问题:

  1. 列是层级的,需要平铺
  2. 行是平铺的,展示不出来层级结构

看文档支持自定义树形结构,按照文档的例子,大概要进行这样的转换:

// 需要把每行拆成 n个数据 { id: 1,  parentId: null, colA: 1, colB: 2, colC: 3,  name: '行1'},{type:'colA',value_row1:1}{type:'colB',value_row1:2}// 需要把每行拆成 n个数据 { id: 2,  parentId: 1,     colA: 1, colB: 2, colC: 3,  name: '行2'},{type:'colA',value_row2:1}{type:'colB',value_row2:2}

然后配置改成

{columns:['type'],values:['value_row1','value_row2'],rows:[{field:'value_row1',title:'行1',children:[{field:'value_row2',title:'行2'}]}]}

这里大致可以展示出想要的样子,但是会不会有性能问题,因为values和rows都会随着行数的增加而增加,譬如

values: ['value_row1', 'value_row2', ...'value_row10000']
You must be logged in to vote

Replies: 0 comments

Sign up for freeto join this conversation on GitHub. Already have an account?Sign in to comment
Category
Q&A
Labels
None yet
1 participant
@youhan26

[8]ページ先頭

©2009-2025 Movatter.jp