SELECT name,CASE WHEN ANY relation IN relationship SATISFIES relation.id == "id-2" THEN relation.value END AS value where ANY relation IN relationship SATISFIES relation.id == "id-2" END
SELECT mydb.name, relation.value
FROM mydb UNNEST mydb.relationship AS relation
WHERE relation.id = "id-2"
Query 2:
SELECT name, FIRST relation.value FOR relation IN releationship WHEN relation.id = "id-2" END AS value
FROM mydb
WHERE ANY relation IN relationship SATISFIES relation.id = "id-2" END
SELECT name, FIRST relation FOR relation IN relationship WHEN relation.id = “id-2” END AS relationship
FROM mydb
WHERE ANY relation IN relationship SATISFIES relation.id = “id-2” END
if I run this query I will get a result something like this
{
“name”:“name1”,
“relationship”: {
“id”:“id-2”,
“value”:“value-2”
}
}
Here relationship document is not nested in an Array.
If I want a result something like this.
{
“name”:“name1”,
“relationship”: [{
“id”:“id-2”,
“value”:“value-2”
}]
}
Then what should be the query ?
SELECT name, ARRAY_ADD([],FIRST relation FOR relation IN relationship WHEN relation.id = "id-2" END) AS relationship FROM mydb WHERE ANY relation IN relationship SATISFIES relation.id = "id-2" END;