Using contains query for a nested jsonb column
Hi, I'm trying to query a jsonb column using
This works:
But for some reason, when I use an array of values, it doesn't:
Where am I going wrong?
Thanks!
containsThis works:
.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify('0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef'))But for some reason, when I use an array of values, it doesn't:
.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify(['0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef']))Where am I going wrong?
Thanks!
