That's not enough - it only gives me one side. And I can't use bothV() instead - it will give me "distinct couples", which is not what I'm looking for.
On Wednesday, June 3, 2015 at 10:25:41 AM UTC+3, [email protected] wrote: > > 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.
