You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please confirm if bug report does NOT exist already ?
I confirm there is no existing issue for this
Steps to reproduce ?
Short description: This bug needs these conditions: A one-to-many relationship where the key being refrenced needs to be autoincrement/identity. Now, when you try to change the foreign key in a specific way the first record of the primary key list disappears from the selection. This is frustrating and annoying.
Long description:
Step 1: Make SQLite database from the following query:
CREATE TABLE Countries (
ID INTEGER PRIMARY KEY AUTOINCREMENT ,
Name text
);
CREATE TABLE Cities (
ID INTEGER PRIMARY KEY AUTOINCREMENT,
Name text,
Country_ID INTEGER,
FOREIGN KEY (Country_ID)
REFERENCES Countries (ID)
);
INSERT INTO Countries (Name)
VALUES ("Italy"), ("United States"), ("France");
INSERT INTO Cities (Name, Country_ID)
VALUES ("Washington", 2), ("New York", 2), ("Paris", 2);
This creates two tables, one called Countries and another called Cities, each with three entries. Theres a one-to-many constraint where one Country can have multiple cities. As you may notice, Paris is also assigned to USA instead of France, but this is intentional and needed for later.
Step 2: Add the databse as a Data Source in the NocoDB interface, then go to the table "Cities"
Step 3: Go to the "Fields" Menu and enable the refrenced Countries to be shown. After closing that window you should be able to see a list of cities and the countries theyre in. Paris is also assigned to the USA.
All of this was just preperation, the rest is the actual way to replicate the bug.
Step 4: The bug appears when we want to change the assigned Country in a particular way. In the Paris record, click right next to the United States text into the empty space, not onto the text. Now a small cross will appear which allows us to remove the country from the city record. Click that cross.
Step 5: Directly after removing the United States refrence from Paris, click the "+" Symbol in the empty country-field. Now two countries will be listed: USA and France. But the first record from the Countries-table, which is Italy, is missing from the selection: When we close and re-open the menu, Italy re-appears and can be selected and everything works fine. Yes, I know that Paris is not in Italy and in this case I can actually select the correct fields, but in some cases I would need to re-close and then re-open the panel to assign the proper country.
This bug always affects the first record of the table being refrenced and disappears after re-entering the selection window. But I've found this to be very frustrating for my colleagues during a small trial at work. Sometimes people misklick the wrong entry and then want to correct it. This confuses non-tech-savy people a lot.
Desired Behavior
I would expect the list to display all entries right away, like this:
Project Details
NocoDB used as Docker: no, but bug appears both in the desktop standalone version and in docker.
NocoDB version: 0.205.1
Database used in NC_DB_URL: sqlite3
Project was created by clicking: Nothing
OS on which NocoDB is running: Window 10x64, Docker Linux shows the same bug
Attachments
No response
The text was updated successfully, but these errors were encountered:
Please confirm if bug report does NOT exist already ?
Steps to reproduce ?
Short description: This bug needs these conditions: A one-to-many relationship where the key being refrenced needs to be autoincrement/identity. Now, when you try to change the foreign key in a specific way the first record of the primary key list disappears from the selection. This is frustrating and annoying.
Long description:
Step 1: Make SQLite database from the following query:
This creates two tables, one called Countries and another called Cities, each with three entries. Theres a one-to-many constraint where one Country can have multiple cities. As you may notice, Paris is also assigned to USA instead of France, but this is intentional and needed for later.
Step 2: Add the databse as a Data Source in the NocoDB interface, then go to the table "Cities"
Step 3: Go to the "Fields" Menu and enable the refrenced Countries to be shown. After closing that window you should be able to see a list of cities and the countries theyre in. Paris is also assigned to the USA.
All of this was just preperation, the rest is the actual way to replicate the bug.
Step 5: Directly after removing the United States refrence from Paris, click the "+" Symbol in the empty country-field. Now two countries will be listed: USA and France. But the first record from the Countries-table, which is Italy, is missing from the selection: When we close and re-open the menu, Italy re-appears and can be selected and everything works fine. Yes, I know that Paris is not in Italy and in this case I can actually select the correct fields, but in some cases I would need to re-close and then re-open the panel to assign the proper country.
This bug always affects the first record of the table being refrenced and disappears after re-entering the selection window. But I've found this to be very frustrating for my colleagues during a small trial at work. Sometimes people misklick the wrong entry and then want to correct it. This confuses non-tech-savy people a lot.
Desired Behavior
I would expect the list to display all entries right away, like this:
Project Details
NocoDB used as Docker: no, but bug appears both in the desktop standalone version and in docker.
NocoDB version: 0.205.1
Database used in NC_DB_URL: sqlite3
Project was created by clicking: Nothing
OS on which NocoDB is running: Window 10x64, Docker Linux shows the same bug
Attachments
No response
The text was updated successfully, but these errors were encountered: