Open
Description
👟 Reproduction steps
- Create 3 collection ( pincode, address, business) shared the schema below
- Populate Pincode collection first
- Then try to create a business document via flutter-sdk
- Head over to Console and go to newly create document and head-over to document overview page
- Scroll down and you will be not able to see the pincode linked
{
"projectId": "646357508f207e68e91a",
"projectName": "monofyi-dev-app",
"databases": [
{
"$id": "6451d90b58e5630094e5",
"name": "dev",
"$createdAt": "2023-05-16T10:23:07.015+00:00",
"$updatedAt": "2023-05-16T10:23:22.542+00:00"
}
],
"collections": [
{
"$id": "64589deed43114bb68c2",
"$permissions": [
"create(\"users\")",
"read(\"users\")"
],
"databaseId": "6451d90b58e5630094e5",
"name": "phoneNumber",
"enabled": true,
"documentSecurity": false,
"attributes": [
{
"key": "primaryNumber",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 20,
"default": null
},
{
"key": "secondaryNumber",
"type": "string",
"status": "available",
"required": false,
"array": false,
"size": 20,
"default": null
}
],
"indexes": [
{
"key": "idx_primary_number",
"type": "unique",
"status": "available",
"attributes": [
"primaryNumber",
"$createdAt"
],
"orders": [
"ASC",
"ASC"
]
}
]
},
{
"$id": "645c9e293be3c3ee04e1",
"$permissions": [
"create(\"users\")",
"read(\"users\")"
],
"databaseId": "6451d90b58e5630094e5",
"name": "beat",
"enabled": true,
"documentSecurity": true,
"attributes": [
{
"key": "beatName",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 30,
"default": null
},
{
"key": "beatNumber",
"type": "integer",
"status": "available",
"required": true,
"array": false,
"min": 1,
"max": 100,
"default": null
},
{
"key": "endLocation",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 30,
"default": null
},
{
"key": "startLocation",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 30,
"default": null
},
{
"key": "beatDay",
"type": "string",
"status": "available",
"required": true,
"array": false,
"elements": [
"monday",
"tuesday",
"wednesday",
"thursday",
"friday",
"saturday",
"sunday"
],
"format": "enum",
"default": null
},
{
"key": "clientLink",
"type": "relationship",
"status": "available",
"required": false,
"array": false,
"relatedCollection": "645c9e65e26c80f4779f",
"relationType": "oneToMany",
"twoWay": false,
"twoWayKey": "645c9e293be3c3ee04e1",
"onDelete": "restrict",
"side": "parent"
}
],
"indexes": []
},
{
"$id": "645c9e65e26c80f4779f",
"$permissions": [
"create(\"users\")",
"read(\"users\")"
],
"databaseId": "6451d90b58e5630094e5",
"name": "client",
"enabled": true,
"documentSecurity": true,
"attributes": [
{
"key": "businessName",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 50,
"default": null
},
{
"key": "ownerName",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 50,
"default": null
},
{
"key": "beatLink",
"type": "relationship",
"status": "available",
"required": false,
"array": false,
"relatedCollection": "645c9e293be3c3ee04e1",
"relationType": "manyToOne",
"twoWay": false,
"twoWayKey": "645c9e65e26c80f4779f",
"onDelete": "restrict",
"side": "parent"
},
{
"key": "phoneNumberLink",
"type": "relationship",
"status": "available",
"required": false,
"array": false,
"relatedCollection": "64589deed43114bb68c2",
"relationType": "oneToOne",
"twoWay": false,
"twoWayKey": "645c9e65e26c80f4779f",
"onDelete": "cascade",
"side": "parent"
},
{
"key": "addressLink",
"type": "relationship",
"status": "available",
"required": false,
"array": false,
"relatedCollection": "645dd41d254b2cb36d94",
"relationType": "oneToOne",
"twoWay": false,
"twoWayKey": "645c9e65e26c80f4779f",
"onDelete": "cascade",
"side": "parent"
}
],
"indexes": []
},
{
"$id": "645dd18bdf8bf219aa71",
"$permissions": [
"read(\"users\")"
],
"databaseId": "6451d90b58e5630094e5",
"name": "pincode",
"enabled": true,
"documentSecurity": false,
"attributes": [
{
"key": "districtName",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 40,
"default": null
},
{
"key": "stateName",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 40,
"default": null
},
{
"key": "stateTin",
"type": "integer",
"status": "available",
"required": true,
"array": false,
"min": 1,
"max": 100,
"default": null
},
{
"key": "pincode",
"type": "integer",
"status": "available",
"required": true,
"array": false,
"min": 100000,
"max": 999999,
"default": null
},
{
"key": "stateCode",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 10,
"default": null
}
],
"indexes": []
},
{
"$id": "645dd41d254b2cb36d94",
"$permissions": [
"create(\"users\")",
"read(\"users\")"
],
"databaseId": "6451d90b58e5630094e5",
"name": "address",
"enabled": true,
"documentSecurity": false,
"attributes": [
{
"key": "locality",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 50,
"default": null
},
{
"key": "pincodeLink",
"type": "relationship",
"status": "available",
"required": false,
"array": false,
"relatedCollection": "645dd18bdf8bf219aa71",
"relationType": "manyToOne",
"twoWay": false,
"twoWayKey": "645dd41d254b2cb36d94",
"onDelete": "restrict",
"side": "parent"
}
],
"indexes": []
},
{
"$id": "645dfb8b2a79a0be4927",
"$permissions": [
"create(\"users\")",
"read(\"users\")"
],
"databaseId": "6451d90b58e5630094e5",
"name": "business",
"enabled": true,
"documentSecurity": false,
"attributes": [
{
"key": "businessTeamLink",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 40,
"default": null
},
{
"key": "ownerName",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 40,
"default": null
},
{
"key": "businessName",
"type": "string",
"status": "available",
"required": true,
"array": false,
"size": 49,
"default": null
},
{
"key": "phoneNumberLink",
"type": "relationship",
"status": "available",
"required": false,
"array": false,
"relatedCollection": "64589deed43114bb68c2",
"relationType": "oneToOne",
"twoWay": false,
"twoWayKey": "645dfb8b2a79a0be4927",
"onDelete": "cascade",
"side": "parent"
},
{
"key": "addressLink",
"type": "relationship",
"status": "available",
"required": false,
"array": false,
"relatedCollection": "645dd41d254b2cb36d94",
"relationType": "oneToOne",
"twoWay": false,
"twoWayKey": "645dfb8b2a79a0be4927",
"onDelete": "cascade",
"side": "parent"
}
],
"indexes": []
}
]
}
👍 Expected behavior
Should have show the linked pincode-id
👎 Actual Behavior
Pincode linked-id doesn't showup
🎲 Appwrite version
Version 1.3.x
💻 Operating system
Linux
🧱 Your Environment
AWS EC2 instance, Appwrite version 1.3.4
👀 Have you spent some time to check if this issue has been raised before?
- I checked and didn't find similar issue
🏢 Have you read the Code of Conduct?
- I have read the Code of Conduct