Using contains query for a nested jsonb column

Hi, I'm trying to query a jsonb column using

contains

contains

and an array of values to match but I'm getting stuck.

This works:

.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify('0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef'))

.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify('0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef'))

.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify('0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef'))

.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']))

.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify(['0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef']))

.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify(['0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef']))

.contains('metadata->addresses->0->knownAddresses->0->interpreter', JSON.stringify(['0x74b2463005b2cd9f0f6f3ffe25aa8f965f780bef']))

Where am I going wrong?

Thanks!

No replies yetBe the first to reply to this messageJoin