@cloudbase/wx-cloud-client-sdk）在云开发 MYSQL模型的使用过程中 关联嵌套查询中字段为什么会丢失？关联嵌套查询是否有层级限制
我目前场景 有活动、用户 、活动用户报名中间表 三个数据模型
当我在小程序中使用 sdk 调用模型查询时 返回记录中的 _activityUser 中只有 _id和 status ，而 user 字段丢失
查询代码如下：
activityModel.list({
pageSize: 100,
select: {
_id: true,
name: true,
detail: true,
startTime: true,
endTime: true,
cover: true,
_activityUser: {
_id: true,
user: {
_id: true,
nickname: true,
avatar: true
},
status: true,
}
}
})返回结果如下
（模型配置如下）
活动模型 activity
{
"previewTableName": "activity-preview",
"publishCacheStatus": "ready",
"subType": "database",
"schema": {
"x-primary-column": "name",
"x-kind": "tcb",
"x-defaultMethods": [
"wedaCreate",
"wedaDelete",
"wedaUpdate",
"wedaGetItem",
"wedaGetList",
"wedaGetRecords",
"wedaBatchCreate",
"wedaBatchUpdate",
"wedaBatchDelete"
],
"type": "object",
"x-relatedType": "exist",
"x-viewId": "view-6szt0n18y8",
"required": [],
"properties": {
"owner": {
"default": "",
"x-system": true,
"x-id": "5ddbb0d",
"name": "owner",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 4,
"title": "所有人",
"type": "string",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"_mainDep": {
"x-system": true,
"x-id": "f806870",
"format": "father-son",
"name": "_mainDep",
"x-hidden": true,
"title": "所属主管部门",
"type": "string",
"x-index": 7,
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_department"
}
},
"_activityUser": {
"name": "_activityUser",
"format": "one-many",
"deleteWay": "doNothing",
"title": "_activityUser",
"type": "array",
"items": {
"type": "object",
"properties": {
"_id": {
"name": "_id",
"title": "数据标识",
"type": "string"
}
}
},
"x-parent": {
"parentFieldKey": "activity",
"parentFieldTitle": "活动信息",
"parentDataSourceName": "activityUser"
}
},
"cover": {
"x-image-size": 5242880,
"x-required": false,
"x-keyPath": "",
"x-id": "6c32dd53",
"format": "x-image",
"description": "活动主图",
"type": "string",
"x-index": 6,
"title": "活动主图",
"x-unique": false,
"maxLength": 1024
},
"createdAt": {
"default": 0,
"x-system": true,
"x-id": "dbb2450",
"format": "datetime",
"x-index": 2,
"type": "number",
"title": "创建时间",
"x-unique": false
},
"createBy": {
"default": "",
"x-system": true,
"x-id": "d090827",
"name": "createBy",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 5,
"type": "string",
"title": "创建人",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"updateBy": {
"default": "",
"x-system": true,
"x-id": "93a079a",
"name": "updateBy",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 6,
"type": "string",
"title": "修改人",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"price": {
"x-required": false,
"default": 0,
"x-keyPath": "",
"x-id": "6e6218c5",
"format": "",
"description": "活动报名价格",
"type": "number",
"x-index": 14,
"title": "报名价格",
"x-unique": false
},
"_openid": {
"default": "",
"x-system": true,
"x-id": "85a8dc1",
"name": "_openid",
"format": "",
"pattern": "",
"description": "仅微信云开发下使用",
"x-index": 45,
"title": "记录创建者",
"type": "string",
"x-unique": false
},
"name": {
"x-required": false,
"x-keyPath": "",
"x-id": "ae7f1815",
"format": "",
"description": "活动名称",
"type": "string",
"x-index": 2,
"title": "活动名称",
"x-unique": false,
"maxLength": 4096
},
"startTime": {
"x-required": false,
"x-keyPath": "",
"x-id": "bd654b5d",
"format": "datetime",
"description": "",
"type": "number",
"x-index": 47,
"title": "开始时间",
"x-unique": false
},
"detail": {
"x-required": false,
"x-keyPath": "",
"x-id": "9223512b",
"format": "",
"description": "活动详情",
"type": "string",
"x-index": 4,
"title": "活动详情",
"x-unique": false,
"maxLength": 4096
},
"_id": {
"default": "",
"x-system": true,
"x-id": "93d85df",
"format": "",
"pattern": "",
"x-index": 1,
"type": "string",
"title": "数据标识",
"x-unique": true
},
"endTime": {
"x-required": false,
"x-keyPath": "",
"x-id": "2bfbb968",
"format": "datetime",
"description": "",
"type": "number",
"x-index": 49,
"title": "结束时间",
"x-unique": false
},
"status": {
"x-keyPath": "",
"x-id": "6bd387e5",
"format": "x-enum",
"description": "活动状态",
"x-option-name": "ACTIVITY_STATUS",
"type": "string",
"x-index": 16,
"title": "活动状态",
"x-unique": false,
"x-required": false,
"default": "0",
"x-enum-type": "general-option",
"x-multi-select": false,
"maxLength": 64
},
"updatedAt": {
"default": 0,
"x-system": true,
"x-id": "adb96c0",
"format": "datetime",
"x-index": 3,
"title": "更新时间",
"type": "number",
"x-unique": false
}
}
},
"dbInstanceType": "MYSQL",
"title": "活动表",
"name": "activity",
"dbLinkType": "internal",
"tableNameRule": "only_name",
"type": "database",
"updateTime": "2025-05-08T18:39:55",
"publishedTableName": "activity",
"id": "data-4GHF7et3y",
"dbSourceType": "internal_mysql",
"methods": [],
"fun": "{\"onlineVersion\": 19, \"previewVersion\": 18, \"onlinePublishAt\": 1746729595775, \"prviewPublishAt\": 1746729595378}",
"publishStatus": 1,
"configuration": {}
}用户模型 user
{
"previewTableName": "user-preview",
"publishCacheStatus": "ready",
"subType": "database",
"schema": {
"x-primary-column": "nickname",
"x-kind": "tcb",
"x-defaultMethods": [
"wedaCreate",
"wedaDelete",
"wedaUpdate",
"wedaGetItem",
"wedaGetList",
"wedaGetRecords",
"wedaBatchCreate",
"wedaBatchUpdate",
"wedaBatchDelete"
],
"type": "object",
"x-relatedType": "exist",
"x-viewId": "view-6szlf4epsg",
"required": [],
"properties": {
"owner": {
"default": "",
"x-system": true,
"x-id": "cdeb0a8",
"name": "owner",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 4,
"title": "所有人",
"type": "string",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"_mainDep": {
"x-system": true,
"x-id": "5cd138a",
"format": "father-son",
"name": "_mainDep",
"x-hidden": true,
"title": "所属主管部门",
"type": "string",
"x-index": 7,
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_department"
}
},
"starSign": {
"x-keyPath": "",
"x-id": "efa34a7c",
"format": "x-enum",
"description": "",
"x-option-name": "START_SIGN",
"type": "string",
"x-index": 29,
"title": "星座",
"x-unique": false,
"x-required": false,
"x-enum-type": "general-option",
"x-multi-select": false,
"maxLength": 64
},
"weight": {
"x-required": false,
"x-keyPath": "",
"x-id": "25c4295e",
"format": "",
"numberCount": 0,
"description": " 体重",
"type": "number",
"x-index": 10,
"title": "体重",
"x-unique": false
},
"avatar": {
"x-image-size": 5242880,
"x-required": false,
"x-keyPath": "",
"x-id": "84a8f2fd",
"format": "x-image",
"description": "用户头像",
"type": "string",
"x-index": 4,
"title": "头像",
"x-unique": false,
"maxLength": 1024
},
"_activityUser": {
"name": "_activityUser",
"format": "one-many",
"deleteWay": "doNothing",
"title": "_activityUser",
"type": "array",
"items": {
"type": "object",
"properties": {
"_id": {
"name": "_id",
"title": "数据标识",
"type": "string"
}
}
},
"x-parent": {
"parentFieldKey": "user",
"parentFieldTitle": "user",
"parentDataSourceName": "activityUser"
}
},
"score": {
"x-required": false,
"default": 0,
"x-keyPath": "",
"x-id": "34e2ce4d",
"format": "",
"numberCount": 0,
"description": "用户积分",
"type": "number",
"x-index": 16,
"title": "用户积分",
"x-unique": false
},
"createdAt": {
"default": 0,
"x-system": true,
"x-id": "225fa72",
"format": "datetime",
"x-index": 2,
"type": "number",
"title": "创建时间",
"x-unique": false
},
"vipLevel": {
"x-required": false,
"x-keyPath": "",
"x-id": "56a3b778",
"format": "",
"numberCount": 0,
"description": "vip 等级",
"type": "number",
"x-index": 31,
"title": "vip 等级",
"minimum": 0,
"x-unique": false
},
"createBy": {
"default": "",
"x-system": true,
"x-id": "475b45f",
"name": "createBy",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 5,
"type": "string",
"title": "创建人",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"updateBy": {
"default": "",
"x-system": true,
"x-id": "93a079a",
"name": "updateBy",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 6,
"type": "string",
"title": "修改人",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"_openid": {
"default": "",
"x-system": true,
"x-id": "749f823",
"name": "_openid",
"format": "",
"pattern": "",
"description": "仅微信云开发下使用",
"x-index": 45,
"title": "记录创建者",
"type": "string",
"x-unique": false
},
"nickname": {
"x-required": false,
"x-keyPath": "",
"x-id": "71c3b662",
"format": "",
"description": " 用户昵称",
"type": "string",
"x-index": 2,
"title": "昵称",
"x-unique": false,
"maxLength": 4096
},
"mbti": {
"x-required": false,
"x-keyPath": "",
"x-id": "42265ac7",
"format": "",
"description": "用户 MBTI",
"type": "string",
"x-index": 12,
"title": "MBTI",
"x-unique": false,
"maxLength": 4096
},
"attribute": {
"x-keyPath": "",
"x-id": "23b85eeb",
"format": "x-enum",
"description": "用户属性\nTOP \nBOTTOM\nVERS\nSIDE\n",
"x-option-name": "ATTRIBUTE",
"type": "string",
"x-index": 14,
"title": "用户属性",
"x-unique": false,
"x-required": false,
"x-enum-type": "general-option",
"x-multi-select": false,
"maxLength": 64
},
"_id": {
"default": "",
"x-system": true,
"x-id": "3979d1d",
"format": "",
"pattern": "",
"x-index": 1,
"type": "string",
"title": "数据标识",
"x-unique": true
},
"height": {
"x-required": false,
"x-keyPath": "",
"x-id": "abdd54d8",
"format": "",
"numberCount": 0,
"maximum": 300,
"description": " 身高单位cm",
"type": "number",
"x-index": 8,
"title": "身高",
"minimum": 0,
"x-unique": false
},
"updatedAt": {
"default": 0,
"x-system": true,
"x-id": "8c1c341",
"format": "datetime",
"x-index": 3,
"title": "更新时间",
"type": "number",
"x-unique": false
}
}
},
"dbInstanceType": "MYSQL",
"title": "用户模型",
"name": "user",
"dbLinkType": "internal",
"tableNameRule": "only_name",
"type": "database",
"updateTime": "2025-05-08T18:39:56",
"publishedTableName": "user",
"id": "data-4GHgZnt7z",
"dbSourceType": "internal_mysql",
"methods": [],
"fun": "{\"onlineVersion\": 14, \"previewVersion\": 13, \"onlinePublishAt\": 1746729596210, \"prviewPublishAt\": 1746729595513}",
"publishStatus": 1,
"configuration": {}
}用户报名中间 模型 activityUser
{
"previewTableName": "activityUser-preview",
"publishCacheStatus": "ready",
"subType": "database",
"schema": {
"x-primary-column": "_id",
"x-kind": "tcb",
"x-defaultMethods": [
"wedaCreate",
"wedaDelete",
"wedaUpdate",
"wedaGetItem",
"wedaGetList",
"wedaGetRecords",
"wedaBatchCreate",
"wedaBatchUpdate",
"wedaBatchDelete"
],
"type": "object",
"x-relatedType": "exist",
"x-viewId": "view-6t92rqaoo0",
"required": [],
"properties": {
"owner": {
"default": "",
"x-system": true,
"x-id": "7975957",
"name": "owner",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 4,
"title": "所有人",
"type": "string",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"_mainDep": {
"x-system": true,
"x-id": "a71b130",
"format": "father-son",
"name": "_mainDep",
"x-hidden": true,
"title": "所属主管部门",
"type": "string",
"x-index": 7,
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_department"
}
},
"createdAt": {
"default": 0,
"x-system": true,
"x-id": "39947d5",
"format": "datetime",
"x-index": 2,
"type": "number",
"title": "创建时间",
"x-unique": false
},
"createBy": {
"default": "",
"x-system": true,
"x-id": "ecba1da",
"name": "createBy",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 5,
"type": "string",
"title": "创建人",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"activity": {
"x-keyPath": "",
"x-id": "de21435d",
"format": "many-one",
"description": "",
"type": "object",
"x-index": 47,
"title": "活动信息",
"list": [
{
"x-id": "wymg4okr",
"name": "_id",
"pId": "de21435d",
"title": "数据标识",
"type": "string"
}
],
"x-unique": false,
"required": [],
"x-parent": {
"parentFieldKey": "_activityUser",
"parentFieldTitle": "_activityUser",
"parentDataSourceName": "activity"
},
"x-required": false,
"name": "activity",
"deleteWay": "doNothing",
"properties": {
"_id": {
"name": "_id",
"title": "数据标识",
"type": "string"
}
}
},
"updateBy": {
"default": "",
"x-system": true,
"x-id": "93a079a",
"name": "updateBy",
"format": "father-son",
"pattern": "",
"x-hidden": true,
"x-index": 6,
"type": "string",
"title": "修改人",
"x-unique": false,
"x-parent": {
"fatherAction": "judge",
"type": "father-son",
"parentDataSourceName": "sys_user"
}
},
"_openid": {
"default": "",
"x-system": true,
"x-id": "dae87e1",
"name": "_openid",
"format": "",
"pattern": "",
"description": "仅微信云开发下使用",
"x-index": 45,
"title": "记录创建者",
"type": "string",
"x-unique": false
},
"_id": {
"default": "",
"x-system": true,
"x-id": "efc291b",
"format": "",
"pattern": "",
"x-index": 1,
"type": "string",
"title": "数据标识",
"x-unique": true
},
"user": {
"x-keyPath": "",
"x-id": "655ead2b",
"format": "many-one",
"description": "",
"type": "object",
"x-index": 49,
"title": "user",
"list": [
{
"x-id": "i9fllzso",
"name": "_id",
"pId": "655ead2b",
"title": "数据标识",
"type": "string"
}
],
"x-unique": false,
"required": [],
"x-parent": {
"parentFieldKey": "_activityUser",
"parentFieldTitle": "_activityUser",
"parentDataSourceName": "user"
},
"x-required": false,
"name": "user",
"deleteWay": "doNothing",
"properties": {
"_id": {
"name": "_id",
"title": "数据标识",
"type": "string"
}
}
},
"status": {
"x-required": false,
"x-keyPath": "",
"x-id": "752867bb",
"format": "",
"numberCount": 0,
"description": "",
"type": "number",
"x-index": 6,
"title": "状态",
"x-unique": false
},
"updatedAt": {
"default": 0,
"x-system": true,
"x-id": "f47b89b",
"format": "datetime",
"x-index": 3,
"title": "更新时间",
"type": "number",
"x-unique": false
}
}
},
"dbInstanceType": "MYSQL",
"title": "活动报名表",
"name": "activityUser",
"dbLinkType": "internal",
"tableNameRule": "only_name",
"type": "database",
"updateTime": "2025-05-08T18:39:56",
"publishedTableName": "activityUser",
"id": "data-4H0Uj569t",
"dbSourceType": "internal_mysql",
"methods": [],
"fun": "{\"onlineVersion\": 10, \"previewVersion\": 9, \"onlinePublishAt\": 1746729596026, \"prviewPublishAt\": 1746729595511}",
"publishStatus": 1,
"configuration": {}
}请问是什么问题。
回答
和开发者交流更多问题细节吧，去 写回答
相关文章
相似问题
相关问答用户
请输入您想邀请的人
腾讯云开发者
