WebAPI报表查询接口支持“条件”页签相关查询参数，可以和“快捷”页签的条件进行组合查询

发布版本：8.1.0.20230921

上线日期：2023.9.21

补丁号：PT-151002

新特性介绍

• WebAPI报表查询接口支持“条件”页签相关查询参数

操作指引

1WebAPI报表查询接口请求报文构造“条件”页签查询参数

特性效果展示

WebAPI报表查询 请求报文里面增加“FilterString”节点用于承载“条件”页签查询参数，格式如下：

{
    "FieldKeys": "返回字段，多个字段使用英文逗号分隔，必录",
    "SchemeId": "过滤方案ID，非必录",
    "StartRow": 0开始行索引，起始从0开始,
    "Limit": 单次查询允许返回的最大行数，最大允许10000，超过10000需要分页取数,
    "FilterString": [/*【条件】页签条件，非必录*/
        {
            "Left": "左括号(，有则填，无则留空",
            "FieldName": "字段名，【条件】或【高级】页签中的字段标识",
            "Compare": "比较符ID，可以在API在线测试页面生成",
            "FieldValue": "过滤值",
            "Right": "右括号)",
            "Logic": "逻辑词，AND或者OR"
        },
        {
            "Left": "左括号(，有则填，无则留空",
            "FieldName": "字段名",
            "Compare": "比较符ID，可以在API在线测试页面生成",
            "FieldValue": "过滤值",
            "Right": "右括号)",
            "Logic": "逻辑词，AND或者OR"
        }
    ],
    "Model": { 快捷页签查询条件数据包 }
}

“FilterString”可以在WebAPI在线测试页面自动生成：

1.WebAPI测试页面点击“填写测试数据”

2.设置相关查询条件，点击“返回数据”按钮，生成示例报文

{
    "FieldKeys": "FPurchaseOrgId,FBillNo,FDate,FSUPPLIERNAME,FMATERIALID,FMATERIALNAME,FMaterialModel,FDELIVERYDATE,FUnitId,FCurrencyId,FOrderQty,FTAXPRICE,FOrderAmount,FReceiveNumber,FReceiveQty,FReceiveAmount,FEnterNumber,FImportQty,FImportAmount,FIMPORTNOTAXAMOUNT,FReturnNumber,FReturnQty,FReturnAmount,FPAYNUMBER,FSETACCOUNTTYPE,FPAYQTY,FPAYAMOUNT,FINVOICENUMBER,FINVOICEQTY,FINVOICEAMOUNT,FRECPAYBILLNUMBER,FRECPAYBILLAMOUNT,FPAYBILLNUMBER,FPAYBILLAMOUNT,FSETADJAMOUNT,FPAYWRITOFFAMOUNT,FSPEWOFFAMOUNT",
    "SchemeId": "",
    "StartRow": 0,
    "Limit": 2000,
    "IsVerifyBaseDataField": "true",
    "FilterString": [{"FieldName":"FSupplierNumber","Compare":"67","Value":"VEN00001","Left":"","Right":"","Logic":"0"},{"FieldName":"FPurchaseOrgNumber","Compare":"67","Value":"103","Left":"","Right":"","Logic":"0"}],
    "Model": {
        "FPurchaseOrgIdList": "100039",
        "FOrderStartDate": "2001-09-14 00:00:00",
        "FOrderEndDate": "2023-09-14 00:00:00",
        "FBusinessType": "CG",
        "FDocumentStatus": "C",
        "FLineStatus": "C"
    }
}