Retrieving intermediate nodes with variable length relationship in Neo4j
I'm using the variable length relationship feature in a cypher query, and it seems to be mostly working. However I want to include the intermediate node(s) if any in the results and I can't figure out how to best achieve this.
A simplified example is a query like this
MATCH (a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN a,b LIMIT 100
The a and b nodes are retrieved as expected and in a few cases they are connected where the path length is 1. But in most cases they are disconnected because the intermediate node (path length 2) is not included in the results. The 2 hop query would look like this:
MATCH (a:MOL)-[:F2EDGE]-(i:F2)-[:F2EDGE]-(b:MOL) RETURN a,i,b LIMIT 100
How can I achieve this?
neo4j cypher
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
add a comment |
I'm using the variable length relationship feature in a cypher query, and it seems to be mostly working. However I want to include the intermediate node(s) if any in the results and I can't figure out how to best achieve this.
A simplified example is a query like this
MATCH (a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN a,b LIMIT 100
The a and b nodes are retrieved as expected and in a few cases they are connected where the path length is 1. But in most cases they are disconnected because the intermediate node (path length 2) is not included in the results. The 2 hop query would look like this:
MATCH (a:MOL)-[:F2EDGE]-(i:F2)-[:F2EDGE]-(b:MOL) RETURN a,i,b LIMIT 100
How can I achieve this?
neo4j cypher
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
add a comment |
I'm using the variable length relationship feature in a cypher query, and it seems to be mostly working. However I want to include the intermediate node(s) if any in the results and I can't figure out how to best achieve this.
A simplified example is a query like this
MATCH (a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN a,b LIMIT 100
The a and b nodes are retrieved as expected and in a few cases they are connected where the path length is 1. But in most cases they are disconnected because the intermediate node (path length 2) is not included in the results. The 2 hop query would look like this:
MATCH (a:MOL)-[:F2EDGE]-(i:F2)-[:F2EDGE]-(b:MOL) RETURN a,i,b LIMIT 100
How can I achieve this?
neo4j cypher
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
I'm using the variable length relationship feature in a cypher query, and it seems to be mostly working. However I want to include the intermediate node(s) if any in the results and I can't figure out how to best achieve this.
A simplified example is a query like this
MATCH (a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN a,b LIMIT 100
The a and b nodes are retrieved as expected and in a few cases they are connected where the path length is 1. But in most cases they are disconnected because the intermediate node (path length 2) is not included in the results. The 2 hop query would look like this:
MATCH (a:MOL)-[:F2EDGE]-(i:F2)-[:F2EDGE]-(b:MOL) RETURN a,i,b LIMIT 100
How can I achieve this?
neo4j cypher
neo4j cypher
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
asked Nov 25 '18 at 10:16
tdudgeontdudgeon
557
557
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You have to define a path and return it like that :
MATCH p=(a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN p LIMIT 100
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53466512%2fretrieving-intermediate-nodes-with-variable-length-relationship-in-neo4j%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You have to define a path and return it like that :
MATCH p=(a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN p LIMIT 100
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
add a comment |
You have to define a path and return it like that :
MATCH p=(a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN p LIMIT 100
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
add a comment |
You have to define a path and return it like that :
MATCH p=(a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN p LIMIT 100
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
You have to define a path and return it like that :
MATCH p=(a:MOL)-[:F2EDGE*1..2]-(b:MOL) RETURN p LIMIT 100
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
answered Nov 26 '18 at 10:46
logisimalogisima
5,2661927
5,2661927
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53466512%2fretrieving-intermediate-nodes-with-variable-length-relationship-in-neo4j%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
