Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
02-16-2021 07:36 PM
Hello, I tried to do this:
USE saguenay MATCH (i:Immeuble) WHERE exists(i.latitude) AND i.logements = 4
CALL
{
WITH i
USE suivi
MATCH (si:Immeuble {uuid:i.uuid})
RETURN si.couleur AS couleur
}
RETURN i.latitude AS lat, i.longitude AS lng, i.dureePossession AS duree, i.uuid AS uuid, couleur, 'saguenay' AS secteur
And I got this error:
Nested subqueries must use the same graph as their parent query.
Attempted to access graph suivi
"USE suivi"
And then I got sad, if I can't do that, I have to rethink the whole model.
Fabric is kind of useless if we can only use it with the UNION clause.
02-16-2021 09:13 PM
I figured out something who works, but there is a lot of weird limitations with a virtual database.
CALL
{
USE quebec MATCH (i:Immeuble) WHERE exists(i.latitude) AND i.logements = 6
RETURN properties(i) AS i
}
CALL
{
WITH i
USE suivi
OPTIONAL MATCH (si:Immeuble {uuid:i.uuid})
RETURN si.couleur AS couleur
}
RETURN i.latitude AS lat, i.longitude AS lng, i.dureePossession AS duree, i.uuid AS uuid, couleur, 'saguenay' AS secteur
For now it works, hoping some future upgrades will remove some of theses weird not intuitive limitations:
I think Fabric need a lot of intuitiveness improvement to fit with Cypher's intuitiveness.
But still, it's powerful and performance looks ok for now.
All the sessions of the conference are now available online