云函数调用云数据库的分组统计,一直报错 TypeError: db.collection(...).groupBy is not a function
'use strict';
exports.main = async (event, context) => {
const db = uniCloud.database();
sql_param.enable = 1;
const rst = await db.collection('mr-record').groupBy("wx_openid").groupField('sum(mile_num) mile_sum').get();
//event为客户端上传的参数
console.log('=== unicloud record sum : ')
console.log(event)
console.log(rst);
//返回数据给客户端
return rst;
};
常安
groupBy能实现返回全部字段吗,我想用来去重。distinct方法只能返回field字段而我需要拿到全部字段
2022-03-23 12:14