🐛 Bug Report: Linked Document ID Doesn't show in Document Overview Page

[Vedsaga]

👟 Reproduction steps

1. Create 3 collection ( pincode, address, business) shared the schema below
2. Populate Pincode collection first
3. Then try to create a business document via flutter-sdk
4. Head over to Console and go to newly create document and head-over to document overview page
5. 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?

• [X] I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• [X] I have read the Code of Conduct

[Vedsaga]

Reason is found https://discord.com/channels/564160730845151244/1105516551744000130/1108459933831286845

[stnguyen90]

To provide a bit more detail, the problem is the options list doesn't include the previously selected value, so the Console doesn't render the selected option.

[stnguyen90]

This is sort of related to https://github.com/appwrite/appwrite/issues/5454

[Emilien-Lambert]

Do we have a rough idea of when this and related issues will be addressed? My issue appwrite/appwrite#7075 has been closed, but this concern is still with me and really blocking. 🙏

[Emilien-Lambert]

Even on version 1.5.4, the value in the input is not displayed. But it's there, because the cal api works and the result is good.