nfield = 'gid,gid._id as g_id,gid.myid as ngmyid,warehouseid,storagelocation,unit,ncount';
ngroupBy = 'gid,warehouseid,storagelocation,unit';
cpage = 1;
pagesize = 50;
const restmp = dbJQL.collection('my-Inventorymanagement,my-material')
.where(where)
.field(nfield)
.groupBy(ngroupBy)
.groupField('sum(ncount) as sumncount')
.orderBy('gid')
.getTemp();
rwhere = "sumncount!=0"
const ress = await dbJQL.collection(restmp)
.where(rwhere)
.skip((cpage - 1) * pagesize).limit(pagesize)
.get({getCount:true});
还是LZM (作者)
在云函数,const dbJQL = uniCloud.databaseForJQL({
event,
context
});
2024-03-06 16:49
DCloud_uniCloud_WYQ
回复 还是LZM: 看下能不能写一个查询复现这个问题,各个参数都不要使用变量,如果能的话发出来我看下
2024-03-07 16:26