Tencent/APIJSON

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

Open

#624 aberto em 26 de out. de 2023

Ver no GitHub
 (2 comments) (0 reactions) (0 assignees)Java (2.229 forks)batch import
Bug 漏洞help wanted

Métricas do repositório

Stars
 (17.967 stars)
Métricas de merge de PR
 (Mesclagem média 4h 34m) (1 fundiu PR em 30d)

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,因为聚合后只有一个分组。

Guia do colaborador