Hello I have one question about indexing array in subquery, in where condition. Basicly I want just first element of array Array in where condition.
"SELECT META().id FROM database WHERE ANY object in Objects SATISFIES (object.isObject = false OR object.finalObject.isObject = false) END AND (Type = \'type\')"
There can be lot of Objects in array but i need just that first one.
Is that possible in couchbaselite 3.0 ?
Thanks for answers.
EDIT: I want replace WHERE ANY with WHERE FIRST. But I don’t know if its possible