let sql1 = db.collection('ketang-parent').where(
'status==1 && displayorder>=0 && recommendArr in[10]').field("id,bookname,price,images,recommendArr")
.getTemp()
let sql2 = db.collection('ketang-son').field("parentid").getTemp()
db.collection(sql1, sql2).field("bookname,isArray(id['ketang-son']) as isA,id").get()
使用isArray是正确的
let sql1 = db.collection('ketang-parent').where(
'status==1 && displayorder>=0 && recommendArr in[10]').field("id,bookname,price,images,recommendArr")
.getTemp()
let sql2 = db.collection('ketang-son').field("parentid").getTemp()
db.collection(sql1, sql2).field("bookname,size(id['ketang-son']) as isA,id").get()
使用size就报错



7***@qq.com (作者)
是的 都有记录值 下面贴出结果 isArray(id["ketang-son"]) as isA 返回了false
{
"_id": "0a4ec1f962943209077b00b22075b83d",
"bookname": "【精品系列课】",
"id": {
"_value": 264,
"ketang-son": [
{
"_id": "b69f67c0629434330519a24a37808e60",
"parentid": 264
},
{
"_id": "f6e08a646294343305bd355606bbe671",
"parentid": 264
},
{
"_id": "6d85a2b9629434340788b55e1770f3f4",
"parentid": 264
},
{
"_id": "8f75309d62943434061601fb4a987d06",
"parentid": 264
},
{
"_id": "b69f67c0629434350519a26776b2f0cf",
"parentid": 264
},
{
"_id": "0a4ec1f962943437077b68891735110d",
"parentid": 264
},
{
"_id": "0ab5303b6294343706a9a6655f02d3bd",
"parentid": 264
},
{
"_id": "16db756f62943438050d297d146fd1f5",
"parentid": 264
},
{
"_id": "058dfefe62943438063f55be185fb8d1",
"parentid": 264
}
]
},
"isA": false,
"recommendArr": [
2,
10
]
}
2022-05-31 14:12