该JQL在JQL数据库管理器查询正常
const dbCmd=db.command
const whereFilter={
user_id: '6391aea853a7f30001e18627',
school_id: '63be64b3642bcb0001fbf67a',
create_date: dbCmd.gte(1675669190807).and(dbCmd.lte(1675928390807))
}
const order = db
.collection(`xxxxx`)
.where(whereFilter)
.getTemp();
const menu = db
.collection('xxxxx')
.getTemp();
const pack = db
.collection('xxxx')
.getTemp();
db.collection(order, menu, pack)
.orderBy(`create_date`, `desc`)
.limit(10)
.get()
实际代码中运行得到异常结果
function baseGetOrderQuery(clientInfo,options={}) {
const whereFilter={
user_id: '6391aea853a7f30001e18627',
school_id: '63be64b3642bcb0001fbf67a',
create_date: dbCmd.gte(1675669190807).and(dbCmd.lte(1675928390807))
}
const dbJQL = uniCloud.databaseForJQL({
clientInfo
})
dbJQL.setUser({
role: ['admin']
});
const order = dbJQL
.collection(`xxxx`)
.where(whereFilter)
.getTemp();
const menu = dbJQL
.collection('xxxx')
.getTemp();
const pack = dbJQL
.collection('xxxx')
.getTemp();
return {
dbJQL,
order,
menu,
pack
}
}
// 创建基本查询SQL对象
const { dbJQL,order,menu,pack } = baseGetOrderQuery(this.getClientInfo());
const result = await dbJQL
.collection(order, menu, pack)
.orderBy(`create_date`, `desc`)
.limit(10)
.get()
return {
errCode: 0,
myErrCode:0,
data:result
}