言归正传

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

2

### 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",...

两张表进行内链查询时，第二张表查询生成的库为默认sys

7

### Description 查询条件： ```js { "[]": { "join": "&/Tbl_audit_data/pk_uid@", "Tbl_order_query": { //通行车牌 "pass_vehicle_plate": "宁E55369", //通行车牌颜色 "pass_vehicle_color": "黄色", //实际车牌 "actual_veicle_plate": "宁E55369", //实际车牌颜色 "actual_vehicle_color": "黄色", //逃费类型 "ensure_fee_type{}": [ "" ], //发起时间 "start_time%":...