Hi, is there a way to create an index on all a property for all elements in an array in documents?
For example, I can create an index on property ‘tpnc’ for the first element in my ‘variants’ array like this:
create index tpnc_index on PriceServiceCopy(variants[0].tpnc)
or similarly for second element in array like this
create index tpnc_index2 on PriceServiceCopy(variants[1].tpnc)
And in both cases the index speeds up retrieval vastly
But is there a way to create index including all elements of the array, so that I can search for tpnc irrespective of which element of array in which it occurs?
I’ve experimented with ideas like variants.tpnc, variants[].tpnc, or variants[*].tpnc but none seem to work.