Hi, 

In the (brand new) public database on Whisky the following query returns 6 
rows: 

select brand, loc, r. fg from ( select name as brand, 
out("ProducedIn").name as loc, out("ProducedIn").out("InRegion").name as r 
, out("HasFlavours").out("FlavourInGroup").name as fg from Whisky ) where 
brand like "A%"

but if I want to filter on one of the other projected fields, no results 
are returned. 

select brand, loc, r. fg from ( select name as brand, 
out("ProducedIn").name as loc, out("ProducedIn").out("InRegion").name as r 
, out("HasFlavours").out("FlavourInGroup").name as fg from Whisky ) where 
loc like "A%"

Coming from a SQL background, I find this not so intuitive.   How do I 
formulate 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.

Reply via email to