NocoDB can't display the values of a cell when it's of type LinkToAnotherRecord and has hundreds of connections

[nilsreichardt]

Problem

I have a table for email addresses and a table for newsletter subscribers. I added 50.000 subscribers to one newsletter. Therefore, there are 50,000 connections in the "Addresses" field in the newsletter table for the row "Wheelmap".

You can see this also in the video. In the newsletter table, we see only ~30 connections. But when we switch to the email address table, we see that also emails like 7444@test.com have also a connection to the newseltter.

Screen.Recording.2022-06-02.at.21.01.02.mov

The response by the REST API shows the same as the client:

Response

{
    "Id": 0,
    "Name": "Wheelmap",
    "Mailjet ID": "17634",
    "Addresses": [
        {
            "Id": 17076,
            "Email": "17063@test.com",
            "CreatedAt": "2022-06-02T13:37:38.787Z",
            "UpdatedAt": "2022-06-02T18:29:23.967Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 17077,
            "Email": "17064@test.com",
            "CreatedAt": "2022-06-02T13:37:38.798Z",
            "UpdatedAt": "2022-06-02T18:29:23.974Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 17078,
            "Email": "17065@test.com",
            "CreatedAt": "2022-06-02T13:37:38.812Z",
            "UpdatedAt": "2022-06-02T18:29:23.982Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 6,
            "Email": "561fe5b8dc0c45a19@gmail.com",
            "CreatedAt": "2022-06-01T20:19:28.864Z",
            "UpdatedAt": "2022-06-02T17:41:04.185Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 12,
            "Email": "0@test.com",
            "CreatedAt": "2022-06-02T13:32:40.471Z",
            "UpdatedAt": "2022-06-02T18:07:16.208Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 15,
            "Email": "2@test.com",
            "CreatedAt": "2022-06-02T13:33:40.743Z",
            "UpdatedAt": "2022-06-02T18:07:16.240Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 16,
            "Email": "3@test.com",
            "CreatedAt": "2022-06-02T13:33:40.769Z",
            "UpdatedAt": "2022-06-02T18:07:16.249Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 17,
            "Email": "4@test.com",
            "CreatedAt": "2022-06-02T13:33:40.799Z",
            "UpdatedAt": "2022-06-02T18:07:16.260Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 18,
            "Email": "5@test.com",
            "CreatedAt": "2022-06-02T13:33:40.828Z",
            "UpdatedAt": "2022-06-02T18:07:16.272Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 19,
            "Email": "6@test.com",
            "CreatedAt": "2022-06-02T13:33:40.847Z",
            "UpdatedAt": "2022-06-02T18:07:16.290Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 20,
            "Email": "7@test.com",
            "CreatedAt": "2022-06-02T13:33:40.869Z",
            "UpdatedAt": "2022-06-02T18:07:16.306Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 22,
            "Email": "9@test.com",
            "CreatedAt": "2022-06-02T13:33:40.925Z",
            "UpdatedAt": "2022-06-02T18:07:16.330Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 23,
            "Email": "10@test.com",
            "CreatedAt": "2022-06-02T13:33:40.953Z",
            "UpdatedAt": "2022-06-02T18:07:16.336Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 24,
            "Email": "11@test.com",
            "CreatedAt": "2022-06-02T13:33:40.983Z",
            "UpdatedAt": "2022-06-02T18:07:16.341Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 25,
            "Email": "12@test.com",
            "CreatedAt": "2022-06-02T13:33:41.016Z",
            "UpdatedAt": "2022-06-02T18:07:16.353Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 26,
            "Email": "13@test.com",
            "CreatedAt": "2022-06-02T13:33:41.047Z",
            "UpdatedAt": "2022-06-02T18:07:16.365Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 28,
            "Email": "15@test.com",
            "CreatedAt": "2022-06-02T13:33:41.112Z",
            "UpdatedAt": "2022-06-02T18:07:16.387Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 29,
            "Email": "16@test.com",
            "CreatedAt": "2022-06-02T13:33:41.139Z",
            "UpdatedAt": "2022-06-02T18:07:16.402Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 30,
            "Email": "17@test.com",
            "CreatedAt": "2022-06-02T13:33:41.161Z",
            "UpdatedAt": "2022-06-02T18:07:16.409Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        },
        {
            "Id": 31,
            "Email": "18@test.com",
            "CreatedAt": "2022-06-02T13:33:41.191Z",
            "UpdatedAt": "2022-06-02T18:07:16.415Z",
            "emails_id": null,
            "emails_id1": null,
            "newsletter_id": 0,
            "menschen_id": null
        }
    ]
}

What I would expect

I would expect to see all 50.000 connections in the "Wheelmap" row or some kind of pagination. The same for the API.

[dstala]

1.js.zip
Use attached script to reproduce it quickly.

• issue observed only with hm. works fine for mm

[dstala]

noco.db.zip
For SQLite root-db

[github-actions]

Fixed in v0.91.8.