I have a tree with 5 vertices

                                     Folder (a)
                                     /        \
                              (b) File      Folder (c)
                                                /       \
                                         (d) File     Folder (e)

I would like to retrieve the folders that contain a file. So I want to get 
back (a) and (c) from my query. The edges are lightweight edges and are 
labeled 'scopeEdge'. I placed a property on the files in my tree and 
labeled them 'file'. These queries don't work

select out from V where file is not null --> gives back temporary vertices

select from V where out('scopeEdge').file is not null --> gives back (a), 
(b), (c), (d), and (e)

I can get 1 query to work but its really complicated. It makes me think I'm 
doing something wrong. Is there something easier than this?

SELECT FROM (TRAVERSE in('scopedEdge') FROM (SELECT FROM #RID# WHERE file IS 
NOT NULL)) WHERE $depth > 0 --> gives back (a) and (c)



-- 

--- 
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to