How to index two keys of array element

Couchbase Server
1

I have a doc like this:

{ a, b: [ {x:.., y:.., z:...}, ...], c}

I need to query like
WHERE
ANY _b in b satisfies _b.x = ‘foo’ and _b.y = ‘123’ END
AND
ANY _b in b satisfies _b.x = ‘bar’ END

Please help.

2

I am building an index like
(distinct (array {_b.x, _b.y} for _b in b end))

Will update.

UPDATE: did not work, predicate not being pushed down into indexer

I’m not building an index like this:

(distinct (array [_b.x, _b.y] for _b in b end)

And will query like

Where
any [_b.x, _b,.y] = [‘foo’, '123] for _b in b end
and
any [_b.x, _b.y][0] = ‘bar’ for _b in b end

I saw something like this in a forum thread I can’t easily find anymore. Will update.

UPDATE

This worked for the top most predicate:

Where
any [_b.x, _b,.y] = [‘foo’, '123] for _b in b end

This will work for me.

3

Search forums SUCCESSOR you will get relevant posts

1 Like