Thanks @al2o3cr, I tried this approach too by serializing values individually within a list, however it still doesn’t produce the correct results. Not sure if I’m doing it correctly though…
vals = [[%{"name" => "test"}], [%{"name" => "another"}]]
serialized = vals |> Enum.map(fn x -> x |> Jason.encode!() end)
with fragment being:
fragment("? @> ANY(?::jsonb[])",
p.services,
^serialized
)
I don’t think this is necessary, because the raw sql query works as expected without it, it’s just I can’t get ecto to do the same thing ![]()






















