We have an index with a property that stores an array of objects with properties of strings. I want to be able to query against these array of objects to find a document where the objects properties match certain conditions. I.e. where the document contains an array where at least one of its obect has one property status to be success and another property state is equal to performance.
It turns out, to do this, I will need to use a nested query (i believe). However this property with the array of objects containing strings was not created with the type "nested".
What is the best course of action in this case? How can i make the query i desire and if needed how can i update an existing mapping on an index? Ive read in these forums that reindexing is an option but would appreciate some advice on the matter.