Hi, Thanks you for the answer.
Tan On Saturday, 3 September 2016 04:41:56 UTC+7, Oleksandr Gubchenko wrote: > > Hi, > > I've created a little test schema: > > > <https://lh3.googleusercontent.com/-NbXRJ0AcjwE/V8nx1VPr3hI/AAAAAAAAAD8/a5B_lCt9JRoxsdeSRuUh4kCyyeThPyB_ACLcB/s1600/schema.jpg> > > > And used this query to find all products that was viewed but not ordered: > > > select from product where in("viewed").size() > 0 and in("ordered").size() > = 0 > > And here is the output: > > > <https://lh3.googleusercontent.com/-BGWDnlxc1os/V8nyZFgBfgI/AAAAAAAAAEA/qq6DnHlkWtY63EG5VGmrS8Umc6RoUaDNQCLcB/s1600/schema2.jpg> > > > Hope it helps, > > Alex. > > > > > > Il giorno venerdì 2 settembre 2016 23:25:56 UTC+2, Tan Ho ha scritto: >> >> Hi all, >> >> Maybe this is a simple question for you but I was not able to find any >> answer. >> >> I have some vertices of class 'product' which can be 'viewed', 'ordered' >> by 'user'. >> My problem is that I want to get all product where 'viewed' by specific >> user, and it's has not been 'ordered' by any user. >> >> Eg: ProductA <-viewed- User1 >> ProductB <-viewed- User1 >> ProductC <-viewed- User1 >> ProductC <-ordered- User1 >> ProductD <-viewed- User1 >> ProductD <-viewed- User2 >> ProductD <-ordered- User2 >> >> Input: User1 >> Expected result:ProductA, ProductB >> Note: ProductC and ProductD don't exist in result set because they were >> 'ordered' by User1, User2. >> >> I want to get it by using SQL or Match command. >> >> Thanks, >> Tan >> > -- --- 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.
