方法:关联字段携带法
案例:有两个表message和messagexiugai,其中message中的houseid和messagexiugai中的messageid是关联关系,schema如下
//message表
{
"bsonType": "object",
"required": [],
"permission": {
"read": true,
"create": true,
"update": true,
"delete": false
},
"properties": {
"_id": {
"description": "ID,系统自动生成"
"houseid": {
"bsonType": "string",
"enum": {
"collection": "mobilexiugai",
"field": "xiugairen as value,mobilenew as text"
},
"foreignKey": "mobilexiugai.messageid"
},
}
}
// messagexiugai表
{
"bsonType": "object",
"required": [],
"permission": {
"read": true,
"create": true,
"update": true,
"delete": true
},
"properties": {
"_id": {
"description": "ID,系统自动生成"
},
"messageid":{
"bsonType": "string"
},
"mobilenew":{
"bsonType": "string"
},
"xiugairen":{
"bsonType": "string"
},
"time":{
"bsonType":"timestamp"
}
}
}
那么unicloud-db组件想携带messagexiugai中的字段的话用houseid{字段1,字段2}来表示
如下就是携带messagexiugai表中的messageid和_id字段
<unicloud-db ref="udb" :collection="colList"
field="url,xianshi,price,area,zhuangtai,title,city,date,mobile,mobilehave,messageto,location,houseid{mobilenew,_id}"
:where="where" page-data="replace" :orderby="orderby" :getcount="true" :page-size="options.pageSize"
:page-current="options.pageCurrent" v-slot:default="{data,pagination,loading,error,options}"
:options="options" loadtime="manual" @load="onqueryload">