Tencent/APIJSON

分组后再分页,发现total数量不对,后台sql发现统计的是组内数量,请问有其他查询方法吗?

Open

#624 opened on Oct 26, 2023

View on GitHub
 (2 comments) (0 reactions) (0 assignees)Java (17,967 stars) (2,229 forks)batch import
Bug 漏洞help wanted

Description

Description

{ "[]": {

    "VehicleList_count": {
        //数据源
        "@ds": "etcmj",
        "vehicleclass{}": [
            "0"
        ],
        "vehicletype{}": [
            "1"
        ],
        "@order": "maxcnt-",
        "vehicleid$":"鄂QD24S8_0%",
        //汇总日期,范围
        "sumdate%": "2023-10-15,2023-10-17",
        "cntss>=": "3",
        "@group": "vehicleid,sumdate",
        "@column": "vehicleid;sumdate;max(vehicletype):vt;max(vehicleclass):vc;max(cnt):maxcnt;max(cntss):maxcntss",
    },
    // 页码
    "page": 0,
    //每页数量
    "count": 5,
    "query": 2
},
//总数量
"total@": "/[]/total"

以上是我的查询

{ "msg": "success", "total": 18, "code": 200, "data": [ { "VehicleList_count": { "maxcnt": 18, "vehicleid": "鄂QD24S8_0", "sumdate": "2023-10-17", "vc": 0, "maxcntss": 3, "vt": 1, "@ds": "etcmj" } } ], "depth:count|max": "3|5", "time:start|duration|end|parse|sql": "1698283826663|136|1698283826799|7|129", "debug:info|help": " \n提 bug 请发请求和响应的【完整截屏】,没图的自行解决! \n开发者有限的时间和精力主要放在【维护项目源码和文档】上! \n【描述不详细】 或 【文档/常见问题 已有答案】 的问题可能会被忽略!! \n【态度 不文明/不友善】的可能会被踢出群,问题也可能不予解答!!! \n\n 环境信息 \n系统: Linux 3.10.0-1160.el7.x86_64 \n数据库: DEFAULT_DATABASE = MYSQL \nJDK: 1.8.0_222 amd64 \nAPIJSON: 6.1.0 \n \n【常见问题】:https://github.com/Tencent/APIJSON/issues/36 \n【通用文档】:https://github.com/Tencent/APIJSON/blob/master/Document.md \n【视频教程】:https://search.bilibili.com/all?keyword=APIJSON", "ok": true, "sql:generate|cache|execute|maxExecute": "2|0|2|1000000" }

以上是我的查询结果,total 数量显示18 ,想要的结果应该是1,因为聚合后只有一个分组。

Contributor guide