SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: bigint[] && text[] LINE 1: ...ies"."xdo"->'case_study_cats_linked'))::bigint))) && ((ARRAY... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. (SQL: select "tbl_list_of_intermediaries".* from "mvpw1_11" as "tbl_list_of_intermediaries" where (((ARRAY(SELECT (jsonb_array_elements_text("tbl_list_of_intermediaries"."xdo"->'case_study_cats_linked'))::bigint))) && ((ARRAY['3544',' 4508']))))

Hi -

When trying to use the overlap query to find numbers of an ID in a linked record I am getting this error

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: bigint[] && text[] LINE 1: ...ies"."xdo"->'case_study_cats_linked'))::bigint))) && ((ARRAY... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. (SQL: select "tbl_list_of_intermediaries".* from "mvpw1_11" as "tbl_list_of_intermediaries" where (((ARRAY(SELECT (jsonb_array_elements_text("tbl_list_of_intermediaries"."xdo"->'case_study_cats_linked'))::bigint))) && ((ARRAY['3544',' 4508']))))