Hi all, For some features of my application, I had to write queries allowing me to get part of graph.
Here's an example : <https://lh6.googleusercontent.com/-Wiot4OaIQ3g/VLfDYqjE2jI/AAAAAAAAABo/tp__qtqSn74/s1600/SELECT.PNG> Imagine a case where we must get, just in ONE query : - *User*.name - *Picture*.url -* Post*.message *!!! But only for the Category #17:1* -* Comment*.message *!!! But only for a Post of Category #17:1* That's the way I imagine this request : SELECT name, first(out('HAS_PICTURE')).url, $Post.message, set($Post.out('HAS_COMMENT').message) FROM #14:0 LET $Post = ( SELECT FROM ( SELECT expand(out('WROTES')) FROM $parent.$current ) WHERE first(out('HAS_CATEGORY')).@rid = format('#17:1') ) But I think there may be an other way to write it... How you would write this query? -- --- 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.
