nichenqin
commented
4 days ago do you have any filters? @MerlinB
Open MerlinB opened 4 days ago
nichenqin
commented
4 days ago do you have any filters? @MerlinB
nichenqin
commented
4 days ago can you share your table schema? and kanban config
MerlinB
commented
3 days ago No filters.
Schema:
CREATE TABLE IF NOT EXISTS "tblrt88l90a5j" ("id" varchar(50) not null unique, "fldednpqc" varchar(255), "fldzqmmv7" text, "fld66lo24" varchar(255), "createdAt" timestamp default CURRENT_TIMESTAMP not null, "createdBy" text, "updatedAt" timestamp default (CURRENT_TIMESTAMP) not null, "updatedBy" text, "autoIncrement" integer primary key autoincrement, "fldygox3d" json);
CREATE TRIGGER update_at_update_tblrt88l90a5j AFTER UPDATE ON `tblrt88l90a5j`
BEGIN
update `tblrt88l90a5j` SET updatedAt = datetime('now') WHERE id = NEW.id;
END;Here is the output of select * from undb_table where id =="tblrt88l90a5j".
tblrt88l90a5j|Tasks|bas2ds86g7h|spa2mw6t|[{"id":"id","name":"id","type":"id","display":false},{"id":"fldednpqc","name":"Title","type":"string","display":true,"constraint":{"required":true}},{"id":"fldzqmmv7","name":"Description","type":"longText","display":false,"constraint":{}},{"id":"fld66lo24","name":"Status","type":"select","display":false,"defaultValue":"optt77oxk","constraint":{"required":true,"max":1},"option":{"options":[{"id":"optt77oxk","name":"Planning","color":"blue"},{"id":"opt5ssvcf","name":"To Do","color":"yellow"},{"id":"optne0ynb","name":"In Progress","color":"orange"},{"id":"opt49et0u","name":"Done","color":"lime"}]}},{"id":"createdAt","name":"createdAt","type":"createdAt","display":false},{"id":"createdBy","name":"createdBy","type":"createdBy","display":false},{"id":"updatedAt","name":"updatedAt","type":"updatedAt","display":false},{"id":"updatedBy","name":"updatedBy","type":"updatedBy","display":false},{"id":"autoIncrement","name":"autoIncrement","type":"autoIncrement","display":false},{"id":"fldygox3d","name":"Assingee","type":"user","display":false,"constraint":{"required":false}}]|[{"id":"viw9t0ssi","name":"default","type":"grid","isDefault":true},{"id":"viwhq0i7p","name":"View","type":"kanban","isDefault":false,"option":{"showSystemFields":false},"fields":[{"fieldId":"fldednpqc","hidden":false},{"fieldId":"fldzqmmv7","hidden":false},{"fieldId":"fld66lo24","hidden":false},{"fieldId":"fldygox3d","hidden":false},{"fieldId":"id","hidden":false},{"fieldId":"createdAt","hidden":false},{"fieldId":"createdBy","hidden":false},{"fieldId":"updatedAt","hidden":false},{"fieldId":"updatedBy","hidden":false},{"fieldId":"autoIncrement","hidden":false}],"widgets":[],"kanban":{"field":"fld66lo24"}}]|[]||2024-11-10T13:57:34.699Z|gymwwkox3gegupuf|2024-11-10T20:01:03.963Z|gymwwkox3gegupuf|No filters.
Schema:
CREATE TABLE IF NOT EXISTS "tblrt88l90a5j" ("id" varchar(50) not null unique, "fldednpqc" varchar(255), "fldzqmmv7" text, "fld66lo24" varchar(255), "createdAt" timestamp default CURRENT_TIMESTAMP not null, "createdBy" text, "updatedAt" timestamp default (CURRENT_TIMESTAMP) not null, "updatedBy" text, "autoIncrement" integer primary key autoincrement, "fldygox3d" json); CREATE TRIGGER update_at_update_tblrt88l90a5j AFTER UPDATE ON `tblrt88l90a5j` BEGIN update `tblrt88l90a5j` SET updatedAt = datetime('now') WHERE id = NEW.id; END;Here is the output of
select * from undb_table where id =="tblrt88l90a5j".tblrt88l90a5j|Tasks|bas2ds86g7h|spa2mw6t|[{"id":"id","name":"id","type":"id","display":false},{"id":"fldednpqc","name":"Title","type":"string","display":true,"constraint":{"required":true}},{"id":"fldzqmmv7","name":"Description","type":"longText","display":false,"constraint":{}},{"id":"fld66lo24","name":"Status","type":"select","display":false,"defaultValue":"optt77oxk","constraint":{"required":true,"max":1},"option":{"options":[{"id":"optt77oxk","name":"Planning","color":"blue"},{"id":"opt5ssvcf","name":"To Do","color":"yellow"},{"id":"optne0ynb","name":"In Progress","color":"orange"},{"id":"opt49et0u","name":"Done","color":"lime"}]}},{"id":"createdAt","name":"createdAt","type":"createdAt","display":false},{"id":"createdBy","name":"createdBy","type":"createdBy","display":false},{"id":"updatedAt","name":"updatedAt","type":"updatedAt","display":false},{"id":"updatedBy","name":"updatedBy","type":"updatedBy","display":false},{"id":"autoIncrement","name":"autoIncrement","type":"autoIncrement","display":false},{"id":"fldygox3d","name":"Assingee","type":"user","display":false,"constraint":{"required":false}}]|[{"id":"viw9t0ssi","name":"default","type":"grid","isDefault":true},{"id":"viwhq0i7p","name":"View","type":"kanban","isDefault":false,"option":{"showSystemFields":false},"fields":[{"fieldId":"fldednpqc","hidden":false},{"fieldId":"fldzqmmv7","hidden":false},{"fieldId":"fld66lo24","hidden":false},{"fieldId":"fldygox3d","hidden":false},{"fieldId":"id","hidden":false},{"fieldId":"createdAt","hidden":false},{"fieldId":"createdBy","hidden":false},{"fieldId":"updatedAt","hidden":false},{"fieldId":"updatedBy","hidden":false},{"fieldId":"autoIncrement","hidden":false}],"widgets":[],"kanban":{"field":"fld66lo24"}}]|[]||2024-11-10T13:57:34.699Z|gymwwkox3gegupuf|2024-11-10T20:01:03.963Z|gymwwkox3gegupuf|
why your underlying table does not have a select field?
MerlinB
commented
10 hours ago No idea. I have not done anything with the db outside of using the undb gui.
Description
I am facing multiple issues on Kanban:
Rows/items disappearing. There should be an item in the ToDo column but sometimes it's just gone and instead the errors displays in another column (Planning)
Type User columns not displayed correctly
Internal Server errors (See logs)
Reproduction URL
No response
Reproduction steps
Screenshots
No response
Logs
Browsers
No response