Hello everyone, have a very strange issue
I've got a column set to a list of images
And I would like to find the rows that have less than 5 images in that array
Seems pretty straightforward, but it's throwing this error at me-
SQLSTATE[22023]: Invalid parameter value: 7 ERROR: cannot get array length of a scalar (SQL: select count(*) as aggregate from "mvpw1_12" as "GMBs" where jsonb_array_length("GMBs"."xdo"->'landingImagesList') < 5::bigint)I'm sure it's something silly from my side, but can't figure it out, need to summon Ray Deck here somehow haha 😅
Thank you beforehand!