I included 'Linda', 'George' and 'child of' vertices (the last one is mistaken, 'Kate' should be there) because these are starting points. The original problem is to retrieve subgraph of parents and teams which linked directly, to the set of childs, or transitively, to the parents (also direct or not) of starting vertices, in my example childs = Linda + Shaun + Jeff + Donald.
So If we decide that you query is correct then instead of ' id_of_New_York_islanders' should be '[id_of_Linda, id_of_Shaun, id_of_Jeff ,id_of_Donald]' something like that. понедельник, 14 июля 2014 г., 16:52:21 UTC+3 пользователь Andrey Kovalev написал: > > Hi, Vladimir. I also wonder whether it is possible. It would be nice if > OrientDB team gives us a lot of examples of tricky sql queries on some real > graph models. > The query would probably look like: > traverse V.in_root_for, V.out_root_for, V.out_child_of from [ > id_of_New_York_islanders] > > > But I do not get why do you include 'Linda', 'George' and 'child of' > vertices? > > On Monday, 14 July 2014 14:37:53 UTC+1, Vladimir Ziankevich wrote: >> >> At first I am sorry for my question, but I really can't understand how to >> solve my problem. >> >> Imagine, I have a graph of relationships which consists of: >> 1) family tree: one child can heve only one parent >> 2) graph of interests (hockey teams root for...) >> >> Example of the graph: >> >> >> <https://lh6.googleusercontent.com/-2gmc-apHGAw/U8PZ3T4Vc1I/AAAAAAAAABM/wwa19WQtMJ0/s1600/Graph1.png> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> So, the problem is I need to retrieve the subgraph by the several childs, >> f.e. subgraph for Shaun, John, Linda, Jeff - relationship subtree and >> linked teams: >> >> >> >> >> <https://lh4.googleusercontent.com/-gUIiUUxMbvU/U8Pb4JfciII/AAAAAAAAABY/ckGOzn0nHdc/s1600/Graph_highlighed1.png> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> And the result subgraph: >> >> <https://lh6.googleusercontent.com/-f6mUnwyrkL0/U8PcJxGfWBI/AAAAAAAAABg/ozvKup6dWlU/s1600/Subgraph_highlighted1.png> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> I have already read topic abpot >> > -- --- 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/d/optout.
