条件面板

## 条件面板
### 1、创建面板SQL实体

![](/media/202404/2024-04-30_171100_998068.png)

SQL语句示例
```sql
//语句说明：FPID=-1的数据节点为根节点，即条件面板中的分类；各字段与条件面板中配置一一对应
SELECT 'a7f04158-dd24-11ee-96c1-00505687dd32' AS FID,'-1' AS FPID,'合同类型' AS FNAME,'合同类型' AS FDESC,'FTYPE' AS FTOFIELD,'eq' AS QUERYOPERATION,0 AS MCHOICE
UNION ALL
SELECT '0f10839e-dd25-11ee-96c1-00505687dd32' AS FID,'a7f04158-dd24-11ee-96c1-00505687dd32' AS FPID,'工程合同' AS FNAME,'工程合同' AS FDESC,'FTYPE' AS FTOFIELD,'eq' AS QUERYOPERATION,0 AS MCHOICE
UNION ALL
SELECT '43b2a088-dd25-11ee-96c1-00505687dd32' AS FID,'a7f04158-dd24-11ee-96c1-00505687dd32' AS FPID,'采购合同' AS FNAME,'采购合同' AS FDESC,'FTYPE' AS FTOFIELD,'eq' AS QUERYOPERATION,0 AS MCHOICE
UNION ALL
SELECT '9c29d5ef-dd25-11ee-96c1-00505687dd32' AS FID,'-1' AS FPID,'付款方式' AS FNAME,'付款方式' AS FDESC,'FPAYTYPE' AS FTOFIELD,'eq' AS QUERYOPERATION,1 AS MCHOICE
UNION ALL
SELECT 'b13f8015-dd25-11ee-96c1-00505687dd32' AS FID,'9c29d5ef-dd25-11ee-96c1-00505687dd32' AS FPID,'货到付款' AS FNAME,'货到付款' AS FDESC,'FPAYTYPE' AS FTOFIELD,'eq' AS QUERYOPERATION,1 AS MCHOICE
UNION ALL
SELECT 'd33fea69-dd25-11ee-96c1-00505687dd32' AS FID,'9c29d5ef-dd25-11ee-96c1-00505687dd32' AS FPID,'分批付款' AS FNAME,'分批付款' AS FDESC,'FPAYTYPE' AS FTOFIELD,'eq' AS QUERYOPERATION,1 AS MCHOICE
UNION ALL
SELECT 'dedcc644-dd25-11ee-96c1-00505687dd32' AS FID,'9c29d5ef-dd25-11ee-96c1-00505687dd32' AS FPID,'付全款' AS FNAME,'付全款' AS FDESC,'FPAYTYPE' AS FTOFIELD,'eq' AS QUERYOPERATION,1 AS MCHOICE
```

### 2、条件面板配置

![](/media/202404/2024-04-30_171149_573954.png)

条件面板属性说明
1）根节点：默认即可
2）数据集：选择面板SQL数据集
3）父ID字段：绑定实体中的父ID（示例中为FPID字段）
4）ID字段：绑定实体中的ID字段（示例中为FID字段）
5）值字段：用于过滤的字段值（示例中为FNAME字段）
6）目标字段：目标数据集需过滤的字段ID（示例中为FTOFIELD字段）
7）描述字段：条件面板中展示的过滤值（示例中为FDESC字段）
8）是否多选字段：条件面板中同个类别数据是否能同时选中多个作为过滤条件，同类别多选过滤方式为or，值可以为0、1或true、false;值为0或false时，不可多选，为1或true时，可以多选（示例中为MCHOICE字段）
9）操作符字段：即查询操作符，如：eq,like等（参照实体中的查询操作符，示例中为QUERYOPERATION字段）
10）目标数据集：绑定需查询的目标数据

### 3、效果展示

![](/media/202404/2024-04-30_171216_330726.png)