Title: 分组后再分页,发现total数量不对,后台sql发现统计的是组内数量,请问有其他查询方法吗? · Issue #624 · APIJSON/APIJSON · GitHub
Open Graph Title: 分组后再分页,发现total数量不对,后台sql发现统计的是组内数量,请问有其他查询方法吗? · Issue #624 · APIJSON/APIJSON
X Title: 分组后再分页,发现total数量不对,后台sql发现统计的是组内数量,请问有其他查询方法吗? · Issue #624 · APIJSON/APIJSON
Description: Description { "[]": { "VehicleList_count": { //数据源 "@ds": "etcmj", "vehicleclass{}": [ "0" ], "vehicletype{}": [ "1" ], "@order": "maxcnt-", "vehicleid$":"鄂QD24S8_0%", //汇总日期,范围 "sumdate%": "2023-10-15,2023-10-17", "cntss>=": "3", "@grou...
Open Graph Description: Description { "[]": { "VehicleList_count": { //数据源 "@ds": "etcmj", "vehicleclass{}": [ "0" ], "vehicletype{}": [ "1" ], "@order": "maxcnt-", "vehicleid$":"鄂QD24S8_0%", //汇总日期,范围 "sumdate%": "2023-1...
X Description: Description { "[]": { "VehicleList_count": { //数据源 "@ds": "etcmj", "vehicleclass{}": [ "0" ], "vehicletype{}": [ "1" ...
Opengraph URL: https://github.com/APIJSON/APIJSON/issues/624
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"分组后再分页,发现total数量不对,后台sql发现统计的是组内数量,请问有其他查询方法吗?","articleBody":"### Description\n\n{\r\n \"[]\": {\r\n \r\n \"VehicleList_count\": {\r\n //数据源\r\n \"@ds\": \"etcmj\",\r\n \"vehicleclass{}\": [\r\n \"0\"\r\n ],\r\n \"vehicletype{}\": [\r\n \"1\"\r\n ],\r\n \"@order\": \"maxcnt-\",\r\n \"vehicleid$\":\"鄂QD24S8_0%\",\r\n //汇总日期,范围\r\n \"sumdate%\": \"2023-10-15,2023-10-17\",\r\n \"cntss>=\": \"3\",\r\n \"@group\": \"vehicleid,sumdate\",\r\n \"@column\": \"vehicleid;sumdate;max(vehicletype):vt;max(vehicleclass):vc;max(cnt):maxcnt;max(cntss):maxcntss\",\r\n },\r\n // 页码\r\n \"page\": 0,\r\n //每页数量\r\n \"count\": 5,\r\n \"query\": 2\r\n },\r\n //总数量\r\n \"total@\": \"/[]/total\"\r\n\r\n\r\n\r\n以上是我的查询\r\n\r\n{\r\n \"msg\": \"success\",\r\n \"total\": 18,\r\n \"code\": 200,\r\n \"data\": [\r\n {\r\n \"VehicleList_count\": {\r\n \"maxcnt\": 18,\r\n \"vehicleid\": \"鄂QD24S8_0\",\r\n \"sumdate\": \"2023-10-17\",\r\n \"vc\": 0,\r\n \"maxcntss\": 3,\r\n \"vt\": 1,\r\n \"@ds\": \"etcmj\"\r\n }\r\n }\r\n ],\r\n \"depth:count|max\": \"3|5\",\r\n \"time:start|duration|end|parse|sql\": \"1698283826663|136|1698283826799|7|129\",\r\n \"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\",\r\n \"ok\": true,\r\n \"sql:generate|cache|execute|maxExecute\": \"2|0|2|1000000\"\r\n}\r\n\r\n\r\n以上是我的查询结果,total 数量显示18 ,想要的结果应该是1,因为聚合后只有一个分组。","author":{"url":"https://github.com/vchenhao","@type":"Person","name":"vchenhao"},"datePublished":"2023-10-26T01:38:58Z","url":"https://github.com/APIJSON/APIJSON/issues/624"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:43b68625-bd8f-f6d3-fe32-9722a478afd8 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | C550:142C54:312FD9:442AC6:6AFCAF52 |
| html-safe-nonce | 4e9f7fed1f42c4dc24800a9e5a678b1e0fe99d22fbeb602340b1321ca7aef340 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNTUwOjE0MkM1NDozMTJGRDk6NDQyQUM2OjZBRkNBRjUyIiwidmlzaXRvcl9pZCI6IjU4OTE1NzY2NjIyOTM1MjQzMDciLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | a9258901b5358f4efdd43ad21588f9e2b22392b525f38e4eab1de8409b4e483f |
| hovercard-subject-tag | issue:1962551123 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/APIJSON/APIJSON/624/issue_layout |
| twitter:image | https://opengraph.githubassets.com/f09c50a1af4c9f33dea30ed14d079b4e7ac1e327340c7ab65ec1a9161edb7761/APIJSON/APIJSON/issues/624 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/f09c50a1af4c9f33dea30ed14d079b4e7ac1e327340c7ab65ec1a9161edb7761/APIJSON/APIJSON/issues/624 |
| og:image:alt | Description { "[]": { "VehicleList_count": { //数据源 "@ds": "etcmj", "vehicleclass{}": [ "0" ], "vehicletype{}": [ "1" ], "@order": "maxcnt-", "vehicleid$":"鄂QD24S8_0%", //汇总日期,范围 "sumdate%": "2023-1... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | vchenhao |
| hostname | github.com |
| expected-hostname | github.com |
| None | e3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d |
| turbo-cache-control | no-preview |
| go-import | github.com/APIJSON/APIJSON git https://github.com/APIJSON/APIJSON.git |
| octolytics-dimension-user_id | 41146037 |
| octolytics-dimension-user_login | APIJSON |
| octolytics-dimension-repository_id | 74359442 |
| octolytics-dimension-repository_nwo | APIJSON/APIJSON |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 74359442 |
| octolytics-dimension-repository_network_root_nwo | APIJSON/APIJSON |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5410e4bebd3e45b138c853ecef3992279d86d5af |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width