Hi Omega, could you please try with expand() function?
SELECT FROM A WHERE externalId IN (SELECT expand(list(externalId)) FROM B) this should fix the problem Luigi 2015-05-07 9:43 GMT+02:00 Omega Silva <[email protected]>: > Hi All, > > I'm working with a document db where I have two classes (say A and B) > which are not linked but have an attribute which is common (say externalId) > > I'm trying to filter out the entries in A, which are also present in B > (basically do an inner join). I'm using the IN filter. Following is my query > > SELECT FROM A WHERE externalId IN (SELECT list(externalId) FROM B) > > The query does not return results, But there are matching records if you > analyze the data. However, if I copy the result coming from the sub query > (which is a list of external ids) and use that as the list searched by IN, > I get data. > > Much appreciated if someone could shed some light on this. > > Cheers > Omega > > -- > > --- > 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. > -- --- 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.
