If I've understood what you need the answer is "traverse"
https://github.com/orientechnologies/orientdb/wiki/SQL-Traverse
On Tuesday, March 4, 2014 10:15:26 AM UTC+1, Lebnik wrote:
>
> Hi,
>
> I have next classes with data:
>
> orientdb {cities}> select from My
>
>
> ----+-----+--------+--------+------
> # |@RID |out_ |in_ |city
>
>
> ----+-----+--------+--------+------
> 0 |#12:0|[size=2]|[size=2]|Rome
> 1 |#12:1|[size=2]|[size=2]|London
> 2 |#12:2|[size=2]|[size=2]|Berlin
> 3 |#12:3|[size=2]|[size=2]|Madrid
> 4 |#12:4|[size=2]|[size=2]|Paris
>
>
> ----+-----+--------+--------+------
>
>
> orientdb {cities}> select from E
>
>
> ----+------+--------+-----+-----
> # |@RID |distance|out |in
>
>
> ----+------+--------+-----+-----
> 0 |#10:0 |1106 |null |null
> 1 |#10:1 |1106 |#12:0|#12:4
> 2 |#10:2 |1106 |#12:4|#12:0
> 3 |#10:3 |1054 |#12:4|#12:3
> 4 |#10:4 |1054 |#12:3|#12:4
> 5 |#10:5 |1267 |#12:3|#12:1
> 6 |#10:6 |1267 |#12:1|#12:3
> 7 |#10:7 |930 |#12:1|#12:2
> 8 |#10:8 |930 |#12:2|#12:1
> 9 |#10:9 |1183 |#12:2|#12:0
> 10 |#10:10|1183 |#12:0|#12:2
>
>
> ----+------+--------+-----+-----
>
> I need get all subobjects where parent @RID = #10:0 and with depth < 4
>
> Can you help me with make this query?
>
> --
> OrientDB console v.1.7-rc1 (build 0) www.orientechnologies.com
> Type 'help' to display all the commands supported.
> Installing extensions for GREMLIN language v.2.5.0-SNAPSHOT
>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" 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/groups/opt_out.
