Thanks for the quick reply and that's it what I exactly want. 

在 2017年2月10日星期五 UTC+8下午3:41:53,Jan写道:
>
> Hi,
>
> I set up the graph as in the picture, and named the collections 'node' and 
> 'edge'.
>
> Here's my query that returns the result sorted by direct number of 
> children of nodes connected to `node/1`:
>
> FOR node IN 1..1 OUTBOUND 'node/1' edge 
>   LET connections = LENGTH(FOR c IN edge FILTER c._from == node._id RETURN 
> c) 
>   SORT connections DESC 
>   RETURN { _id: node._id, connections }
>
> This produces:
>
> [ 
>   { 
>     "_id" : "node/11", 
>     "connections" : 8 
>   }, 
>   { 
>     "_id" : "node/21", 
>     "connections" : 6 
>   }, 
>   { 
>     "_id" : "node/2", 
>     "connections" : 4 
>   }, 
>   { 
>     "_id" : "node/7", 
>     "connections" : 3 
>   } 
> ]
>
> Is that what you're after?
>
> Best regards
> J
>
>
> Am Freitag, 10. Februar 2017 04:50:25 UTC+1 schrieb Feng Wang:
>>
>>
>>
>>
>>
>>
>>
>> <https://lh3.googleusercontent.com/-QPNk6tcpTlA/WJ00YTapMUI/AAAAAAAACkM/4f2PLpZR8aU77K31fD3rwt6uVyN2TyDAwCLcB/s1600/graph.png>
>>
>> *Figure 1*
>>
>> As shown in Fig.1,  I want to achieve the function like this:   starting 
>>  at the vertex 'node/1' and return the results sorted by the degree of ( 
>> 'node/21' ,'node/11','node/2','node/7')
>>
>> for example in Fig.1, there are 6 nodes connected with 'node/21' ( does 
>> not include 'node/1') ,  8 nodes connected with 'node/11' ,  4 nodes 
>> connected with 'node/2',   3 nodes connected with 'node/7'  
>>
>> with AQL I want to return vertex results like : [ 'node/11' 
>> ,'node/21','node/2','node/7' ] or vertex info ......
>>
>>
>> btw, I try to used Subqueries , LENGTH() and sort  but it did not works...
>>
>>
>>
>>
>>
>>

-- 
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.

Reply via email to