---
title: "树表格"
description: "WebBuilder 树表格的数据加载与 XWL 配置。"
---

> Documentation Index
> Fetch the complete documentation index at: https://ag.879818327.xyz/llms.txt
> Use this file to discover all available pages before exploring further.

# 树表格

**树表格与普通表格类似,用于类似文件夹进行分级**

**树表格在每次进行展开时对数据库进行查询所以可以通过每次查询传参进行区分查询的内容,即可以不使用同一SQL命令**

##  树表格使用

![image-20210223145030538](/webbulider/image-20210223145030538.png)

**xwl数据源中设置dataprovider设置为tree**

```javascript
//判断是否是根节点加载
var node = operation.node;
operation.params.parentDept = node.isRoot() ? -1 : operation.node.data.DEPT_ID;
```

## XWL

**例子**

```sql
select DEPT_NAME as "text",
DEPT_ID,
PARENT_DEPT,
0 as "DONE_CHECK",
case when (select count(*) from WB_EMPLOYEE_DEPT b where b.PARENT_DEPT=a.DEPT_ID)>0 then 'false' else 'true' end as "leaf"
from WB_EMPLOYEE_DEPT a where PARENT_DEPT={?parentDept?} order by ORDER_INDEX
```

**最主要是"leaf"用于区分是否可继续展开**

Source: https://ag.879818327.xyz/webbuilder/gridtree/index.mdx