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.