🐛 [BUG] - Kanban View broken

[MerlinB]

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

Create a Kanban View - Outside of that I'm not sure

Screenshots

No response

Logs

undb  | {"level":20,"time":1732178066042,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.1736799999998766,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066043,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.14088099999935366,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066055,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.2297210000033374,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066056,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.1796009999998205,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066058,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":["opt49et0u",20,0],"duration":0.27240100000199163,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066059,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.13344000000142842,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066061,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\"","params":["opt49et0u"],"duration":0.20648000000073807,"msg":"kysely.query"}
undb  | {"level":50,"time":1732178066062,"pid":7,"hostname":"baf058d3f7db","module":"@undb/trpc","requestId":"b324951d-ac65-4b16-80c8-89905f5c09a6","responseTime":17.329435000003286,"type":"query","path":"record.list","error":{"code":"INTERNAL_SERVER_ERROR","name":"TRPCError","originalLine":19,"originalColumn":10},"msg":"trpc.error: no result"}
undb  | {"level":20,"time":1732178066064,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.13975999999820488,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066064,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.09020000000236905,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066072,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.22560100000191596,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066073,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.17152100000021164,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066074,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":["optne0ynb",20,0],"duration":0.24528099999952246,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066075,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.12791999999899417,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066077,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\"","params":["optne0ynb"],"duration":0.21272099999987404,"msg":"kysely.query"}
undb  | {"level":50,"time":1732178066078,"pid":7,"hostname":"baf058d3f7db","module":"@undb/trpc","requestId":"992f1b77-69c0-438f-90fe-130b705c9dd9","responseTime":12.959735999997065,"type":"query","path":"record.list","error":{"code":"INTERNAL_SERVER_ERROR","name":"TRPCError","originalLine":19,"originalColumn":10},"msg":"trpc.error: no result"}
undb  | {"level":20,"time":1732178066087,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.11895999999978812,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066088,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.10116100000232109,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066099,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.2885210000022198,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066101,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.2024409999976342,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066103,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" is null group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":[20,0],"duration":0.3396409999986645,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066104,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.1835609999980079,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066107,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" is null group by \"tblrt88l90a5j\".\"id\"","params":[],"duration":0.2765209999997751,"msg":"kysely.query"}
undb  | {"level":50,"time":1732178066108,"pid":7,"hostname":"baf058d3f7db","module":"@undb/trpc","requestId":"c1b97c7a-43ce-434c-86e7-869ffd8d78ea","responseTime":18.971402999999555,"type":"query","path":"record.list","error":{"code":"INTERNAL_SERVER_ERROR","name":"TRPCError","originalLine":19,"originalColumn":10},"msg":"trpc.error: no result"}
undb  | {"level":20,"time":1732178066119,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.11676100000113365,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066120,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.10564099999828613,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066132,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.24716100000296137,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066133,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.186440000001312,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066135,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":["optt77oxk",20,0],"duration":0.30016100000284496,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066136,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.1543210000018007,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178066138,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\"","params":["optt77oxk"],"duration":0.2521210000013525,"msg":"kysely.query"}
undb  | {"level":50,"time":1732178066139,"pid":7,"hostname":"baf058d3f7db","module":"@undb/trpc","requestId":"2ecc9e56-f634-4533-82b6-e919c80a8808","responseTime":18.02567800000179,"type":"query","path":"record.list","error":{"code":"INTERNAL_SERVER_ERROR","name":"TRPCError","originalLine":19,"originalColumn":10},"msg":"trpc.error: no result"}

AND

undb  | {"level":20,"time":1732178559810,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.19372099998872727,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559811,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.1676009999937378,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559826,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.19408099999418482,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559827,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.15148100000806153,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559829,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":["optt77oxk",20,0],"duration":0.2730819999706,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559829,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.12396100000478327,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559831,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\"","params":["optt77oxk"],"duration":0.20136100001400337,"msg":"kysely.query"}
undb  | {"level":50,"time":1732178559831,"pid":7,"hostname":"baf058d3f7db","module":"@undb/trpc","requestId":"da11bd0e-0926-4fee-9730-b94cfd804349","responseTime":19.19066100002965,"type":"query","path":"record.list","error":{"code":"INTERNAL_SERVER_ERROR","name":"TRPCError","originalLine":19,"originalColumn":10},"msg":"trpc.error: no result"}
undb  | {"level":20,"time":1732178559833,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.09372100001201034,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559833,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.08048000000417233,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559840,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.18340099998749793,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559841,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.16412099997978657,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559842,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":["opt49et0u",20,0],"duration":0.2341209999867715,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559843,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.1280409999890253,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559844,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\"","params":["opt49et0u"],"duration":0.19300100003601983,"msg":"kysely.query"}
undb  | {"level":50,"time":1732178559844,"pid":7,"hostname":"baf058d3f7db","module":"@undb/trpc","requestId":"85f90f3d-e46b-462d-83b9-e239ecc9f52c","responseTime":10.78525700001046,"type":"query","path":"record.list","error":{"code":"INTERNAL_SERVER_ERROR","name":"TRPCError","originalLine":19,"originalColumn":10},"msg":"trpc.error: no result"}
undb  | {"level":20,"time":1732178559846,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.09176099998876452,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559846,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.07895999995525926,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559853,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.19732100004330277,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559854,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.16180100000929087,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559855,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":["optne0ynb",20,0],"duration":0.23164100002031773,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559856,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.14360100001795217,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559857,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" = ? group by \"tblrt88l90a5j\".\"id\"","params":["optne0ynb"],"duration":0.23208099999465048,"msg":"kysely.query"}
undb  | {"level":50,"time":1732178559857,"pid":7,"hostname":"baf058d3f7db","module":"@undb/trpc","requestId":"3c3910ef-8f79-4112-9aea-4b74327be4d3","responseTime":10.917536999972071,"type":"query","path":"record.list","error":{"code":"INTERNAL_SERVER_ERROR","name":"TRPCError","originalLine":19,"originalColumn":10},"msg":"trpc.error: no result"}
undb  | {"level":20,"time":1732178559864,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space\" where (\"undb_space\".\"deleted_at\" is null and \"undb_space\".\"id\" = ?)","params":["spa2mw6t"],"duration":0.37576199998147786,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559865,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select * from \"undb_space_member\" where (\"undb_space_member\".\"user_id\" = ? and \"undb_space_member\".\"space_id\" = ?)","params":["gymwwkox3gegupuf","spa2mw6t"],"duration":0.1342399999848567,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559873,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where (\"undb_table\".\"space_id\" = ? and \"undb_table\".\"id\" = ?)","params":["spa2mw6t","tblrt88l90a5j"],"duration":0.19240100000752136,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559874,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.16084099997533485,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559876,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" is null group by \"tblrt88l90a5j\".\"id\" order by \"tblrt88l90a5j\".\"autoIncrement\" asc limit ? offset ?","params":[20,0],"duration":0.288961999991443,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559876,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"select \"undb_table\".* from \"undb_table\" where \"undb_table\".\"space_id\" = ?","params":["spa2mw6t"],"duration":0.12228000001050532,"msg":"kysely.query"}
undb  | {"level":20,"time":1732178559878,"pid":7,"hostname":"baf058d3f7db","module":"qb","query":"with \"fldygox3d_expanded\" as (select \"tblrt88l90a5j\".\"id\", \"json_each\".\"value\" as \"fldygox3d\" from \"tblrt88l90a5j\", json_each(COALESCE(tblrt88l90a5j.fldygox3d, '[]')) as \"json_each\"), \"fldygox3d\" as (select \"fldygox3d_expanded\".\"id\", \"undb_user\".\"username\" as \"username\", \"undb_user\".\"email\" as \"email\" from \"fldygox3d_expanded\" inner join \"undb_user\" on \"fldygox3d_expanded\".\"fldygox3d\" = \"undb_user\".\"id\") select \"tblrt88l90a5j\".\"id\", \"tblrt88l90a5j\".\"fldednpqc\", \"tblrt88l90a5j\".\"fldzqmmv7\", \"tblrt88l90a5j\".\"fld66lo24\", \"tblrt88l90a5j\".\"fldygox3d\", case when \"tblrt88l90a5j\".\"fldygox3d\" is null then null else json_group_array(json_object('username', coalesce(\"fldygox3d\".\"username\", NULL), 'email', coalesce(\"fldygox3d\".\"email\", NULL))) end as \"$fldygox3d\", count(*) as \"total\" from \"tblrt88l90a5j\" left join \"fldygox3d\" on \"tblrt88l90a5j\".\"id\" = \"fldygox3d\".\"id\" where \"tblrt88l90a5j\".\"fld66lo24\" is null group by \"tblrt88l90a5j\".\"id\"","params":[],"duration":0.20284099999116734,"msg":"kysely.query"}

Browsers

No response

[nichenqin]

do you have any filters? @MerlinB

[nichenqin]

can you share your table schema? and kanban config

[MerlinB]

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|