René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:43b68625-bd8f-f6d3-fe32-9722a478afd8
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC550:142C54:312FD9:442AC6:6AFCAF52
html-safe-nonce4e9f7fed1f42c4dc24800a9e5a678b1e0fe99d22fbeb602340b1321ca7aef340
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNTUwOjE0MkM1NDozMTJGRDk6NDQyQUM2OjZBRkNBRjUyIiwidmlzaXRvcl9pZCI6IjU4OTE1NzY2NjIyOTM1MjQzMDciLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmaca9258901b5358f4efdd43ad21588f9e2b22392b525f38e4eab1de8409b4e483f
hovercard-subject-tagissue:1962551123
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/APIJSON/APIJSON/624/issue_layout
twitter:imagehttps://opengraph.githubassets.com/f09c50a1af4c9f33dea30ed14d079b4e7ac1e327340c7ab65ec1a9161edb7761/APIJSON/APIJSON/issues/624
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/f09c50a1af4c9f33dea30ed14d079b4e7ac1e327340c7ab65ec1a9161edb7761/APIJSON/APIJSON/issues/624
og:image:altDescription { "[]": { "VehicleList_count": { //数据源 "@ds": "etcmj", "vehicleclass{}": [ "0" ], "vehicletype{}": [ "1" ], "@order": "maxcnt-", "vehicleid$":"鄂QD24S8_0%", //汇总日期,范围 "sumdate%": "2023-1...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamevchenhao
hostnamegithub.com
expected-hostnamegithub.com
Nonee3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d
turbo-cache-controlno-preview
go-importgithub.com/APIJSON/APIJSON git https://github.com/APIJSON/APIJSON.git
octolytics-dimension-user_id41146037
octolytics-dimension-user_loginAPIJSON
octolytics-dimension-repository_id74359442
octolytics-dimension-repository_nwoAPIJSON/APIJSON
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id74359442
octolytics-dimension-repository_network_root_nwoAPIJSON/APIJSON
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release5410e4bebd3e45b138c853ecef3992279d86d5af
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/APIJSON/APIJSON/issues/624#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FAPIJSON%2FAPIJSON%2Fissues%2F624
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FAPIJSON%2FAPIJSON%2Fissues%2F624
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=APIJSON%2FAPIJSON
Reloadhttps://github.com/APIJSON/APIJSON/issues/624
Reloadhttps://github.com/APIJSON/APIJSON/issues/624
Reloadhttps://github.com/APIJSON/APIJSON/issues/624
APIJSONhttps://github.com/APIJSON
APIJSONhttps://github.com/APIJSON/APIJSON
Codehttps://github.com/APIJSON/APIJSON
Issues237 (237)https://github.com/APIJSON/APIJSON/issues
Pull requestshttps://github.com/APIJSON/APIJSON/pulls
Actionshttps://github.com/APIJSON/APIJSON/actions
Wikihttps://github.com/APIJSON/APIJSON/wiki
Security and qualityhttps://github.com/APIJSON/APIJSON/security
Insightshttps://github.com/APIJSON/APIJSON/insights
https://github.com/APIJSON/APIJSON
New issuehttps://github.com/login?return_to=https://github.com/APIJSON/APIJSON/issues/624
New issuehttps://github.com/login?return_to=https://github.com/APIJSON/APIJSON/issues/624
#884https://github.com/APIJSON/APIJSON/pull/884
分组后再分页,发现total数量不对,后台sql发现统计的是组内数量,请问有其他查询方法吗?https://github.com/APIJSON/APIJSON/issues/624#top
#884https://github.com/APIJSON/APIJSON/pull/884
Bug 漏洞https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Bug%20%E6%BC%8F%E6%B4%9E%22
help wanted请求帮助https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
https://github.com/vchenhao
vchenhaohttps://github.com/vchenhao
on Oct 26, 2023https://github.com/APIJSON/APIJSON/issues/624#issue-1962551123
@dshttps://github.com/ds
#36https://github.com/APIJSON/APIJSON/issues/36
https://github.com/Tencent/APIJSON/blob/master/Document.mdhttps://github.com/Tencent/APIJSON/blob/master/Document.md
https://search.bilibili.com/all?keyword=APIJSONhttps://search.bilibili.com/all?keyword=APIJSON
https://github.com/vchenhao
vchenhaohttps://github.com/vchenhao
on Oct 26, 2023https://github.com/APIJSON/APIJSON/issues/624#issuecomment-1780593549
@fromhttps://github.com/from
vchenhaohttps://github.com/vchenhao
completedhttps://github.com/APIJSON/APIJSON/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Oct 26, 2023https://github.com/APIJSON/APIJSON/issues/624#event-10776116201
TommyLemonhttps://github.com/TommyLemon
Bug 漏洞https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Bug%20%E6%BC%8F%E6%B4%9E%22
on Nov 12, 2023https://github.com/APIJSON/APIJSON/issues/624#event-10934250274
https://github.com/TommyLemon
TommyLemonhttps://github.com/TommyLemon
on Nov 12, 2023https://github.com/APIJSON/APIJSON/issues/624#issuecomment-1807088948
https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractParser.javahttps://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractParser.java
https://private-user-images.githubusercontent.com/5738175/282293510-015f21e0-1b65-4775-8173-3ff63bd3e38d.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3OTQ5NDUxNTEsIm5iZiI6MTc5NDk0NDg1MSwicGF0aCI6Ii81NzM4MTc1LzI4MjI5MzUxMC0wMTVmMjFlMC0xYjY1LTQ3NzUtODE3My0zZmY2M2JkM2UzOGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MTExNyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjExMTdUMTk0NzMxWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9N2QyMTBmZDQzZjNjZGZmZTI0YThkMTgwYjIzMmVjN2YwOTZlOWE0OTJmNzYxZDNjOTU5NjFkMWVhYmUwNDY3ZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.J_mL7aDn9vlxPlfesAGZGt6lfWkAPhTR-A36gArZlak
TommyLemonhttps://github.com/TommyLemon
on Nov 12, 2023https://github.com/APIJSON/APIJSON/issues/624#event-10934254474
TommyLemonhttps://github.com/TommyLemon
help wanted请求帮助https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
on Nov 12, 2023https://github.com/APIJSON/APIJSON/issues/624#event-10934254968
TommyLemonhttps://github.com/TommyLemon
completedhttps://github.com/APIJSON/APIJSON/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
fd1f15bhttps://github.com/APIJSON/APIJSON/commit/fd1f15b8b81eba7ae17ca58b09b907eda39aa9e3
on Nov 14, 2026https://github.com/APIJSON/APIJSON/issues/624#event-36096772872
lucadeghttps://github.com/lucadeg
on Nov 16, 2026https://github.com/APIJSON/APIJSON/issues/624#event-36252347910
fix(sql): count groups for HEAD requests with @grouphttps://github.com/lucadeg/APIJSON/commit/fd1f15b8b81eba7ae17ca58b09b907eda39aa9e3
@grouphttps://github.com/group
https://docs.github.com/articles/closing-issues-via-commit-messages
fd1f15bhttps://github.com/lucadeg/APIJSON/commit/fd1f15b8b81eba7ae17ca58b09b907eda39aa9e3
Sign up for freehttps://github.com/signup?return_to=https://github.com/APIJSON/APIJSON/issues/624
Sign in to commenthttps://github.com/login?return_to=https://github.com/APIJSON/APIJSON/issues/624
Bug 漏洞https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Bug%20%E6%BC%8F%E6%B4%9E%22
help wanted请求帮助https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.