Hello,
I'm using a composite database KB that includes two graphs KB.actors and KB.searches
I need to get information about actors that are in KB.actors graph using ids of actors that are the result of a filtre on KB.searches.
I tried this query:
USE KB.searches
MATCH(n:Company) WHERE ...
WITH n.entityId as companyId
USE KB.actors
MATCH(n:Company)-[:ALIAS]->(a:Alias)
WHERE n.entityId=companyId
RETURN companyId, a.term
The query doesn't work "
USE can only appear at the beginning of a (sub-)query
"USE geotrend.actors
Is there any way to join data cross a composite database graphs? is it possible to do it?
Thanks,