Queries for Specific Index in Array Fields

TLDR Joe inquired about searching specific array indexes. Kishore Nallan clarified it's not possible but offered to suggest alternatives.

Photo of Joe
Fri, 05 Nov 2021 14:38:45 UTC

Question: for array types e.g. string[], is it possible to limit search to specific array index(s)? e.g. Find the word "apple", in array_field[2]

Photo of Kishore Nallan
Kishore Nallan
Fri, 05 Nov 2021 14:43:52 UTC

:wave: No that's not possible. May I know what your use case is? Maybe I can suggest something else.

Photo of Joe
Fri, 05 Nov 2021 15:03:17 UTC

I have other ways of achieving the use-case (e.g. multiple separate feilds", thought I would check first though.