三、拼表函数使用说明
附：拼表结构解析
♦表头—displayFields
♦数据集—dataSet
3.1 通过图表 Id 查询拼表（默认加载拼表首页 20 条数据） Fx.BI.queryLwtViewDataById(String viewId)
3.1.1 函数用途
通过viewId查询拼表数据
3.1.2 参数说明
| 参数 | 类型 | 是否必须 | 说明 | 参数示例 |
|---|---|---|---|---|
| viewId | String | 是 | 拼表ID | “BI_lwt_1657506871248” |
3.1.3 函数举例
def(isError,data,errorMsg) = Fx.BI.queryLwtViewDataById("BI_lwt_1657506871248")
if(!isError){
log.info("分页信息:"+data["page"])
log.info("表头信息:"+data["displayFields"])
log.info("数据集:"+data["dataSet"])
}else{
log.info("查询失败:"+errorMsg)
}
3.1.4 返回值说明
| 参数 | 类型 | 说明 |
|---|---|---|
| code | Int | 函数状态码：200：成功403：没有权限500：系统异常 |
| message | String | 返回消息 |
| page | Object | 分页信息 |
| displayFields | Object | 表头信息 |
| dataSet | Object | 结果数据集 |
3.1.5 返回值示例
图表数据返回的结构统一为二维表，成对映射
{
"code": 200,
"message": "success",
"i18nCode": null,
"data": {
"displayFields": [
[
{
"fieldId": "BI_lwt_calc_6ad70579d41f4901aee273eb7e9aeb0b",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_b421df3270824345b6c5dc13f2fea14e",
"fieldName": "年",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_f289f266427f4cedba1a746c6b058298",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_bba3a46afcf14f158855fa733de92205",
"fieldName": "季",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_83cb73bcc82f4f2897e79799d0ff6d9f",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_a010a7cbf99646ae89eef3e6deb64557",
"fieldName": "月",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_7e11d20cdabb47fb9ed0fe6291ee7e2b",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
}
],
[
{
"fieldId": "BI_5be1388756fc11448c4567dc",
"fieldName": "产品线",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "MultiSelectEnum",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "product_line",
"linkObjName": "ProductObj"
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
}
]
],
"dataSet": [
[
{
"value": "产品线1",
"displayValue": "产品线1",
"dataFormatStr": ""
},
{
"value": "2625.0",
"displayValue": "2625",
"dataFormatStr": "0.00"
},
{
"value": "26250.0",
"displayValue": "2.63万",
"dataFormatStr": "0.00"
},
{
"value": "66934.0",
"displayValue": "66934",
"dataFormatStr": "0.00"
},
{
"value": "669340.0",
"displayValue": "66.93万",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0.00",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "23464.0",
"displayValue": "23464",
"dataFormatStr": "0.00"
},
{
"value": "234640.0",
"displayValue": "23.46万",
"dataFormatStr": "0.00"
},
{
"value": "143423.0",
"displayValue": "143423",
"dataFormatStr": "0.00"
},
{
"value": "1434230.0",
"displayValue": "143.42万",
"dataFormatStr": "0.00"
},
{
"value": "18389.0",
"displayValue": "18389",
"dataFormatStr": "0.00"
},
{
"value": "183890.0",
"displayValue": "18.39万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "23464.0",
"displayValue": "23464",
"dataFormatStr": "0.00"
},
{
"value": "234640.0",
"displayValue": "23.46万",
"dataFormatStr": "0.00"
},
{
"value": "143423.0",
"displayValue": "143423",
"dataFormatStr": "0.00"
},
{
"value": "1434230.0",
"displayValue": "143.42万",
"dataFormatStr": "0.00"
},
{
"value": "240947.0",
"displayValue": "240947",
"dataFormatStr": "0.00"
},
{
"value": "2409470.0",
"displayValue": "240.95万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "23464.0",
"displayValue": "23464",
"dataFormatStr": "0.00"
},
{
"value": "234640.0",
"displayValue": "23.46万",
"dataFormatStr": "0.00"
},
{
"value": "547561.0",
"displayValue": "547561",
"dataFormatStr": "0.00"
},
{
"value": "5475610.0",
"displayValue": "547.56万",
"dataFormatStr": "0.00"
},
{
"value": "18389.0",
"displayValue": "18389",
"dataFormatStr": "0.00"
},
{
"value": "183890.0",
"displayValue": "18.39万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "23464.0",
"displayValue": "23464",
"dataFormatStr": "0.00"
},
{
"value": "234640.0",
"displayValue": "23.46万",
"dataFormatStr": "0.00"
},
{
"value": "547561.0",
"displayValue": "547561",
"dataFormatStr": "0.00"
},
{
"value": "5475610.0",
"displayValue": "547.56万",
"dataFormatStr": "0.00"
},
{
"value": "240947.0",
"displayValue": "240947",
"dataFormatStr": "0.00"
},
{
"value": "2409470.0",
"displayValue": "240.95万",
"dataFormatStr": "0.00"
}
]
],
"page": {
"pageSize": 20,
"pageNumber": 1,
"pageCount": 1,
"totalCount": 5
}
}
}
3.2 通过 viewId 和分页信息 page 查询拼表 Fx.BI.queryLwtViewDataByPage(String viewId, Integer pageNumber, Integer pageSize)
3.2.1 函数用途
通过viewId和分页信息page查询拼表,用户可以自定义查询想要查询的页码，并规定每页条数
3.2.2 参数说明
| 参数 | 类型 | 是否必须 | 说明 | 参数示例 |
|---|---|---|---|---|
| viewId | String | 是 | 交叉表ID | “BI_lwt_1657506871248” |
| pageNumber | Integer | 是 | 页码 | 1 |
| pageSize | Integer | 是 | 每页规定条数 | 1 |
3.2.3 函数举例
==========================查询第一页，每页一条数据的交叉表数据===============================
=============================================================================================
def(isError,data,errorMsg) = Fx.BI.queryLwtViewDataByPage("BI_lwt_1657506871248",1,1)
if(!isError){
log.info("分页信息:"+data["page"])
log.info("表头信息:"+data["displayFields"])
log.info("数据集:"+data["dataSet"])
}else{
log.info("查询失败:"+errorMsg)
}
3.2.4 返回值说明
| 参数 | 类型 | 说明 |
|---|---|---|
| code | Int | 函数状态码：200：成功403：没有权限500：系统异常 |
| message | String | 返回消息 |
| page | Object | 分页信息 |
| displayFields | Object | 表头信息 |
| dataSet | Object | 结果数据集 |
3.2.5 返回值示例
图表数据返回的结构统一为二维表，成对映射
{
"code": 200,
"message": "success",
"i18nCode": null,
"data": {
"displayFields": [
[
{
"fieldId": "BI_lwt_calc_390f421f5d51471d889f27fe3bc1849b",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_c51e947793a4448e964e21a19855d637",
"fieldName": "年",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_ba0dcd60e4ca404b9f0c49278a776718",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_ccb483314eae4008a83cce58bf28b36f",
"fieldName": "季",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_a62e283869af4b29885c583f1ddf6934",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_e6f0d1ba2c3c428e9ab9818da6a00ae3",
"fieldName": "月",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_3d6e6fb55d924a61bd6ebec94bab1c84",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
}
],
[
{
"fieldId": "BI_5be1388756fc11448c4567dc",
"fieldName": "产品线",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "MultiSelectEnum",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "product_line",
"linkObjName": "ProductObj"
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
}
]
],
"dataSet": [
[
{
"value": "产品线1",
"displayValue": "产品线1",
"dataFormatStr": ""
},
{
"value": "2625.0",
"displayValue": "2625",
"dataFormatStr": "0.00"
},
{
"value": "26250.0",
"displayValue": "2.63万",
"dataFormatStr": "0.00"
},
{
"value": "66934.0",
"displayValue": "66934",
"dataFormatStr": "0.00"
},
{
"value": "669340.0",
"displayValue": "66.93万",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0.00",
"dataFormatStr": "0.00"
}
]
],
"page": {
"pageSize": 1,
"pageNumber": 1,
"pageCount": 5,
"totalCount": 5
}
}
}
3.3 通过 viewId 和 filterList 查询拼表数据 Fx.BI.queryLwtViewDataByFilter(String viewId, List filterList)
3.3.1 函数用途
通过viewId和筛选范围进行查询拼表
3.3.2 参数说明
| 参数 | 类型 | 是否必须 | 说明 | 参数示例 |
|---|---|---|---|---|
| viewId | String | 是 | 交叉表ID | “BI_62973467376efe000172be38” |
| filterList | Integer | 是 | 筛选条件 | List filterList = [["filterId":"BI_62cb8af6741ac20001debf72","value1":"","value2":"","dateRangeId":6]] |
| 参数 | 类型 | 是否必须 | 说明 | 参数示例 |
| --- | --- | --- | --- | --- |
| filterId | String | 是 | 拼表ID | “BI_lwt_1657506871248” |
| value1 | String | 是 | 筛选值 | “” |
| value2 | Integer | 是 | 筛选值 | ”" |
| dateRangeId | Integer | 否 | 枚举值 | 6 （注意：枚举值见-》6、使用filterList注意事项：日期筛选case和枚举项） |
3.3.3 函数举例
==========================查询筛选的拼表数据===============================
=============================================================================================
List filterList = [["filterId":"BI_62cb8af6741ac20001debf72","value1":"","value2":"","dateRangeId":6]];
def(isError,data,errorMsg) = Fx.BI.queryLwtViewDataByFilter("BI_lwt_1657506871248",filterList)
if(!isError){
log.info("分页信息:"+data["page"])
log.info("表头信息:"+data["displayFields"])
log.info("数据集:"+data["dataSet"])
}else{
log.info("查询失败:"+errorMsg)
}
3.3.4 返回值说明
| 参数 | 类型 | 说明 |
|---|---|---|
| code | Int | 函数状态码：200：成功403：没有权限500：系统异常 |
| message | String | 返回消息 |
| page | Object | 分页信息 |
| displayFields | Object | 表头信息 |
| dataSet | Object | 结果数据集 |
3.3.5 返回值示例
图表数据返回的结构统一为二维表，成对映射
{
"code": 200,
"message": "success",
"i18nCode": null,
"data": {
"displayFields": [
[
{
"fieldId": "BI_lwt_calc_d9cad9232d464077b5eafcd13f60183f",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_228e9fbb9359411faa3f5ee2bb13649b",
"fieldName": "年",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_d2530cb668b64b06ae54a4232b0ccc87",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_399493e3de2c4d299c10d705f188eb49",
"fieldName": "季",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_f3b44d6bb3324183bf164596ea0dbd5c",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_40095e45357947b792fe855350dd84be",
"fieldName": "月",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_8f6ddee4bf9d49c99902f30b769801ea",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
}
],
[
{
"fieldId": "BI_5be1388756fc11448c4567dc",
"fieldName": "产品线",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "MultiSelectEnum",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "product_line",
"linkObjName": "ProductObj"
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
}
]
],
"dataSet": [
[
{
"value": "产品线3",
"displayValue": "产品线3",
"dataFormatStr": ""
},
{
"value": "73976.0",
"displayValue": "73976",
"dataFormatStr": "0.00"
},
{
"value": "739760.0",
"displayValue": "73.98万",
"dataFormatStr": "0.00"
},
{
"value": "19194.0",
"displayValue": "19194",
"dataFormatStr": "0.00"
},
{
"value": "191940.0",
"displayValue": "19.19万",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0.00",
"dataFormatStr": "0.00"
}
],
[
{
"value": "产品线2",
"displayValue": "产品线2",
"dataFormatStr": ""
},
{
"value": "199451.0",
"displayValue": "199451",
"dataFormatStr": "0.00"
},
{
"value": "1994510.0",
"displayValue": "199.45万",
"dataFormatStr": "0.00"
},
{
"value": "47691.0",
"displayValue": "47691",
"dataFormatStr": "0.00"
},
{
"value": "476910.0",
"displayValue": "47.69万",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0.00",
"dataFormatStr": "0.00"
}
],
[
{
"value": "产品线1",
"displayValue": "产品线1",
"dataFormatStr": ""
},
{
"value": "269469.0",
"displayValue": "269469",
"dataFormatStr": "0.00"
},
{
"value": "6041360.0",
"displayValue": "604.14万",
"dataFormatStr": "0.00"
},
{
"value": "66934.0",
"displayValue": "66934",
"dataFormatStr": "0.00"
},
{
"value": "669340.0",
"displayValue": "66.93万",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0.00",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "557336.0",
"displayValue": "557336",
"dataFormatStr": "0.00"
},
{
"value": "5573415.0",
"displayValue": "557.34万",
"dataFormatStr": "0.00"
},
{
"value": "143423.0",
"displayValue": "143423",
"dataFormatStr": "0.00"
},
{
"value": "1434230.0",
"displayValue": "143.42万",
"dataFormatStr": "0.00"
},
{
"value": "18389.0",
"displayValue": "18389",
"dataFormatStr": "0.00"
},
{
"value": "183890.0",
"displayValue": "18.39万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "557336.0",
"displayValue": "557336",
"dataFormatStr": "0.00"
},
{
"value": "5573415.0",
"displayValue": "557.34万",
"dataFormatStr": "0.00"
},
{
"value": "143423.0",
"displayValue": "143423",
"dataFormatStr": "0.00"
},
{
"value": "1434230.0",
"displayValue": "143.42万",
"dataFormatStr": "0.00"
},
{
"value": "240947.0",
"displayValue": "240947",
"dataFormatStr": "0.00"
},
{
"value": "2409470.0",
"displayValue": "240.95万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "557336.0",
"displayValue": "557336",
"dataFormatStr": "0.00"
},
{
"value": "5573415.0",
"displayValue": "557.34万",
"dataFormatStr": "0.00"
},
{
"value": "547561.0",
"displayValue": "547561",
"dataFormatStr": "0.00"
},
{
"value": "5475610.0",
"displayValue": "547.56万",
"dataFormatStr": "0.00"
},
{
"value": "18389.0",
"displayValue": "18389",
"dataFormatStr": "0.00"
},
{
"value": "183890.0",
"displayValue": "18.39万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "557336.0",
"displayValue": "557336",
"dataFormatStr": "0.00"
},
{
"value": "5573415.0",
"displayValue": "557.34万",
"dataFormatStr": "0.00"
},
{
"value": "547561.0",
"displayValue": "547561",
"dataFormatStr": "0.00"
},
{
"value": "5475610.0",
"displayValue": "547.56万",
"dataFormatStr": "0.00"
},
{
"value": "240947.0",
"displayValue": "240947",
"dataFormatStr": "0.00"
},
{
"value": "2409470.0",
"displayValue": "240.95万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "2436277.0",
"displayValue": "2436277",
"dataFormatStr": "0.00"
},
{
"value": "24380370.0",
"displayValue": "2,438.04万",
"dataFormatStr": "0.00"
},
{
"value": "143423.0",
"displayValue": "143423",
"dataFormatStr": "0.00"
},
{
"value": "1434230.0",
"displayValue": "143.42万",
"dataFormatStr": "0.00"
},
{
"value": "18389.0",
"displayValue": "18389",
"dataFormatStr": "0.00"
},
{
"value": "183890.0",
"displayValue": "18.39万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "2436277.0",
"displayValue": "2436277",
"dataFormatStr": "0.00"
},
{
"value": "24380370.0",
"displayValue": "2,438.04万",
"dataFormatStr": "0.00"
},
{
"value": "143423.0",
"displayValue": "143423",
"dataFormatStr": "0.00"
},
{
"value": "1434230.0",
"displayValue": "143.42万",
"dataFormatStr": "0.00"
},
{
"value": "240947.0",
"displayValue": "240947",
"dataFormatStr": "0.00"
},
{
"value": "2409470.0",
"displayValue": "240.95万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "2436277.0",
"displayValue": "2436277",
"dataFormatStr": "0.00"
},
{
"value": "24380370.0",
"displayValue": "2,438.04万",
"dataFormatStr": "0.00"
},
{
"value": "547561.0",
"displayValue": "547561",
"dataFormatStr": "0.00"
},
{
"value": "5475610.0",
"displayValue": "547.56万",
"dataFormatStr": "0.00"
},
{
"value": "18389.0",
"displayValue": "18389",
"dataFormatStr": "0.00"
},
{
"value": "183890.0",
"displayValue": "18.39万",
"dataFormatStr": "0.00"
}
],
[
{
"value": "--",
"displayValue": "--",
"dataFormatStr": ""
},
{
"value": "2436277.0",
"displayValue": "2436277",
"dataFormatStr": "0.00"
},
{
"value": "24380370.0",
"displayValue": "2,438.04万",
"dataFormatStr": "0.00"
},
{
"value": "547561.0",
"displayValue": "547561",
"dataFormatStr": "0.00"
},
{
"value": "5475610.0",
"displayValue": "547.56万",
"dataFormatStr": "0.00"
},
{
"value": "240947.0",
"displayValue": "240947",
"dataFormatStr": "0.00"
},
{
"value": "2409470.0",
"displayValue": "240.95万",
"dataFormatStr": "0.00"
}
]
],
"page": {
"pageSize": 20,
"pageNumber": 1,
"pageCount": 1,
"totalCount": 11
}
}
}
3.4 通过 viewId、分页信息 page 和 filterList 查询拼表数据 Fx.BI.queryLwtViewData(String viewId, Integer pageNumber, Integer pageSize, List filterList)
3.4.1 函数用途
通过viewId和筛选条件filterList、场景defaultFilterOptionId，查询交叉表
3.4.2 参数说明
| 参数 | 类型 | 是否必须 | 说明 | 参数示例 |
|---|---|---|---|---|
| viewId | String | 是 | 交叉表ID | “BI_lwt_1657506871248” |
| filterList | Integer | 是 | 筛选条件 | List filterList = [["filterId":"BI_62cb8af6741ac20001debf72","value1":"","value2":"","dateRangeId":6]] |
| pageNumber | Integer | 是 | 页码 | 1 |
| pageSize | Integer | 是 | 每页的条数 | 1 |
3.4.3 filterList结构说明
| 参数 | 类型 | 是否必须 | 说明 | 参数示例 |
|---|---|---|---|---|
| filterId | String | 是 | 拼表ID | “BI_62973467376efe000172be38” |
| value1 | String | 是 | 筛选范围 | “” |
| value2 | Integer | 是 | 筛选范围 | “” |
| dateRangeId | Integer | 否 | 日期筛选需要用到的枚举值 | 6 （注意：枚举值见-》6、使用filterList注意事项：日期筛选case和枚举项） |
3.4.4 函数举例
==========================通过分页信息page、viewId、筛选器filterList查询的拼表数据===============================
=================================================================================================================
List filterList = [["filterId":"BI_62cb8af6741ac20001debf72","value1":"","value2":"","dateRangeId":6]];
def(isError,data,errorMsg) = Fx.BI.queryLwtViewData("BI_lwt_1657506871248",1,1,filterList)
if(!isError){
log.info("分页信息:"+data["page"])
log.info("表头信息:"+data["displayFields"])
log.info("数据集:"+data["dataSet"])
}else{
log.info("查询失败:"+errorMsg)
3.4.5 返回值说明
| 参数 | 类型 | 说明 |
|---|---|---|
| code | Int | 函数状态码：200：成功403：没有权限500：系统异常 |
| message | String | 返回消息 |
| page | Object | 分页信息 |
| displayFields | Object | 表头信息 |
| dataSet | Object | 结果数据集 |
3.4.6 返回值示例
图表数据返回的结构统一为二维表，成对映射
{
"code": 200,
"message": "success",
"i18nCode": null,
"data": {
"displayFields": [
[
{
"fieldId": "BI_lwt_calc_ddc948d7b23d4a4c9da0f4d27b79d465",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_86273a3178fe4ceab71538462ee13962",
"fieldName": "年",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_35fc27cbe17444d6951fc4a3f82519b6",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_8c5755a7669a41f5ba57e89afc17b459",
"fieldName": "季",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_208110f605e94df2af1333c12c4a89bd",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_e5a5ac5d61924ce0a81699c9668c7b1b",
"fieldName": "月",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
},
{
"fieldId": "BI_lwt_calc_be4b6adce187454ebd35d2a3289eb55c",
"fieldName": "",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "String",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "",
"linkObjName": ""
}
],
[
{
"fieldId": "BI_5be1388756fc11448c4567dc",
"fieldName": "产品线",
"formatStr": "",
"objName": "",
"objectNodeName": null,
"fieldType": "MultiSelectEnum",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "product_line",
"linkObjName": "ProductObj"
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
},
{
"fieldId": "BI_5be3b0ff2563710001ab1b62",
"fieldName": "销售数量(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "quantity",
"linkObjName": ""
},
{
"fieldId": "BI_6178cf99ea585200014b0ef9",
"fieldName": "订单总金额(求和)",
"formatStr": "",
"objName": "订单产品",
"objectNodeName": null,
"fieldType": "Number",
"joinType": "outer",
"refObjName": "",
"dbFieldName": "subtotal",
"linkObjName": ""
}
]
],
"dataSet": [
[
{
"value": "产品线3",
"displayValue": "产品线3",
"dataFormatStr": ""
},
{
"value": "73976.0",
"displayValue": "73976",
"dataFormatStr": "0.00"
},
{
"value": "739760.0",
"displayValue": "73.98万",
"dataFormatStr": "0.00"
},
{
"value": "19194.0",
"displayValue": "19194",
"dataFormatStr": "0.00"
},
{
"value": "191940.0",
"displayValue": "19.19万",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0",
"dataFormatStr": "0.00"
},
{
"value": "0.0",
"displayValue": "0.00",
"dataFormatStr": "0.00"
}
]
],
"page": {
"pageSize": 1,
"pageNumber": 1,
"pageCount": 11,
"totalCount": 11
}
}
}