You could return all vertices of every path `p` und flatten them into one array.
see docu here <https://docs.arangodb.com/3.1/AQL/Functions/Array.html#flatten> RETURN FLATTEN(FOR v,e,p IN 1..3 OUTBOUND "columns/0" `table1` RETURN p. vertices[*].title) or alternative see docu here <https://docs.arangodb.com/3.1/AQL/Advanced/ArrayOperators.html#array-contraction> RETURN (FOR v,e,p IN 1..3 OUTBOUND "columns/0" `table1` RETURN p.vertices [*].title)[**] Am Samstag, 18. März 2017 18:41:12 UTC+1 schrieb Frank Russell: > > How to re-use node as intermediate node ? > > When I return the result as path it have all path walked > [2] A -> B -> C > [3] A -> B -> D > > but when return vertex it remove duplicate vertex B > ["A", "B", "C", "D"] > > Expected result: > ["A", "B", "B", "C", "D"] > > | A | | > |---|---| > | B | | > | C | D | > > Query: > FOR v,e,p IN 1..3 OUTBOUND "columns/0" `table1` RETURN v.title > > > > columns.json > [ > { > "_key": "0", > "id": 0, > "title": "root", > "visible": false > }, > { > "_key": "1", > "id": 1, > "title": "A", > "visible": true > }, > { > "_key": "2", > "id": 2, > "title": "B", > "visible": false > }, > { > "_key": "3", > "id": 3, > "title": "C", > "visible": true > }, > { > "_key": "4", > "id": 4, > "title": "D", > "visible": true > } > ] > > > table1.json > [ > { > "_key": "1", > "_from": "columns/0", > "_to": "columns/1" > }, > { > "_key": "2", > "_from": "columns/1", > "_to": "columns/2" > }, > { > "_key": "4", > "_from": "columns/2", > "_to": "columns/3" > }, > { > "_key": "5", > "_from": "columns/2", > "_to": "columns/4" > } > ] > > > > -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
