Hi, for the first question you can use the DISTINCT clause, for example : SELECT distinct(outV()) FROM Called WHERE start_time>X AND end_time<Y
Bye, Alessandro Il giorno lunedì 1 giugno 2015 20:36:59 UTC+2, Lior Neudorfer ha scritto: > > Hi, > > two small questions from an OrientDB beginner... > > I have a graph with one type of Vertices - "Person" - and one type of > Edges - "Called". > The graph describes phone conversations between people, with each edge > having a "start_time" and "end_time" properties which describe the call's > start and end times. > > For example, to get all the ongoing conversations in a specific time, I > can do SELECT FROM Called WHERE start_time>X AND end_time<Y. > > 1. > I am looking for a query which will return *all people that were having a > conversation in a specific hour*. > When I want to get the people themselves, I'm using SELECT bothV() FROM > Called WHERE start_time>X AND end_time<Y. > The problem with this query is that I get duplicate results - if a person > had multiple calls, I'll get his record multiple times. I don't want to > remove duplicates in the application itself. > > I've tried several strategies to solve this, including dividing it to > multiple queries with LET... but it seems too complicated for a rather > simple query. > Any ideas? > > 2. Continuing that question - is there a single query which will return > all filtered Edges *and* their attached Vertices? In order to optimize > the edge filtering query and do it only once? > > Thanks so much for the help. > This seems like an active group - hope I'll be able to contribute to it in > the future :) > > Lior > -- --- 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.
