Support indexing and querying objects in JSON array about tiedot HOT 3 CLOSED

Can you give an example query with json array?

from tiedot.

So currently:

• If an index is put on an array, all elements in the array are indexed.
• If a query operates on an array, it is applied to each element of the array and any success will include the document in result.

But to make query/index more powerful/useful:

• User will be able to index JSON Object attribute inside an array, for example, put an index on ["a", "b", "c"] will index the "c" value 1 and 2 in the following document:

  {"a": [{"b": {"c": 1}}, {"b", "c": 2}}]}

• Query will be able to operate on JSON object attributes inside an array, similar to the example above.

from tiedot.

Implemented in f88a0b8

from tiedot.