Hi,
I have a table which has a field 'tags' which is a list of tags from another table.
Now I would like to have a query which loads all entries without any tag (tag count = 0)
I tried it with a length filter and a condition to 0:
Unfortunately this throws the following error:
Whoops! An error occurred.
Exception:Â SQLSTATE[22023]: Invalid parameter value: 7 ERROR: cannot get array length of a scalar (SQL: select 'study_program'.* from 'mvpw2_17' as 'study_program' where jsonb_array_length('study_program'.'xdo'->'tags') = 0::bigint
Field config: