Re: [orientdb] Help with SQL query

Sorry, the first query is TRAVERSE in('scopedEdge') FROM ( SELECT expand(in('scopeEdge')) FROM V WHERE file IS NOT NULL ) 2017-06-19 15:26 GMT+02:00 Luigi Dell'Aquila : > Hi Erik, > > I'm afraid I don't completely understand your model: > - how are the edges

Re: [orientdb] Help with SQL query

Hi Erik, I'm afraid I don't completely understand your model: - how are the edges directed? From parent to child or from child to parent? - are File and Folder two different classes that extend V? - what does the "file" property represent? Is it a string or what? If I got it right, you have

Re: [orientdb] Help with SQL query with Count or relationships

Hi syshex which version of ODB do you have ? 2014-12-18 18:32 GMT+01:00 syshex sys...@gmail.com: Hi everyone. Have a schema that goes somewhat along these lines : ( Institute ) ---owner --- ( Contract ) --- hired --- ( Company ) I'm trying to create an SQL query that shows all

Re: [orientdb] Help with SQL query with Count or relationships

Forgot to mention that ! So sorry, Version 2.0 M3 on linux On Thursday, December 18, 2014 7:06:16 PM UTC, Enrico Risa wrote: Hi syshex which version of ODB do you have ? 2014-12-18 18:32 GMT+01:00 syshex sys...@gmail.com javascript:: Hi everyone. Have a schema that goes somewhat

Re: [orientdb] Help with SQL query with Count or relationships

Could you retry with 2.0-rc1. Should fix the behaviour of your latest query 4/5 Il 18/dic/2014 21:55 syshex sys...@gmail.com ha scritto: Forgot to mention that ! So sorry, Version 2.0 M3 on linux On Thursday, December 18, 2014 7:06:16 PM UTC, Enrico Risa wrote: Hi syshex which version

Re: [orientdb] Help with SQL query with Count or relationships

Just gave it a quick spin, the rc1 with the db I'm doing tests with and yes , now things are making sense to me. Query 4 works like I want. Perfect! Thanks so much for taking the time. On Thursday, December 18, 2014 8:58:15 PM UTC, Enrico Risa wrote: Could you retry with 2.0-rc1. Should