及时入坑
及时入坑
  • 发布:2025-04-03 15:16
  • 更新:2025-04-03 17:23
  • 阅读:42

JQL 简单的一对一关联查询怎么写?不是一对多,官网一对多属于嵌套格式。

分类:uniCloud

schema1:

{  
    "bsonType": "object",  
    "required": [],  
    "permission": {  
        "read": true,  
        "create": true,  
        "update": true,  
        "delete": true  
    },  
    "properties": {  
        "_id": {  
            "description": "ID,系统自动生成"  
        },  
        "username": {  
            "description": "用户名称"  
        },  
        "nickname": {  
            "description": "用户昵称"  
        },  
        "openid": {  
            "bsonType": "string",  
            "foreignKey": "byepoor-records.openid",  
            "description": "用户小程序的唯一标识"  
        }  
    }  
}

schema2:

{  
    "bsonType": "object",  
    "required": [],  
    "permission": {  
        "read": true,  
        "create": true,  
        "update": true,  
        "delete": true  
    },  
    "properties": {  
        "_id": {  
            "description": "ID,系统自动生成"  
        },  
        "openid": {  
            "description": "用户小程序的唯一标识"  
        },  
        "maxScore": {  
            "description": "历史最高分"  
        }  
    }  
}

期望结果:

{  
        "_id": "67eb4b58f2949ccbd1a49de2",  
        "nickname": "摆谱",  
        "maxScore": 0,  
        "openid": "wx6239430d15e308ab"  
}

实际结果:

{  
    "_id": "67eb4b58f2949ccbd1a49de2",  
    "nickname": "摆谱",  
    "openid": [{  
        "_id": "67eb4d22862066ed973156f3",  
        "maxScore": 0,  
        "openid": "wx6239430d15e308ab"  
    }]  
}
2025-04-03 15:16 负责人:无 分享
已邀请:
DCloud_uniCloud_CRL

DCloud_uniCloud_CRL

可以用aggregate聚合查询实现。

要回复问题请先登录注册