Neo4j algo.shortestPath with only certain label of relationship
I am new to Neo4j and I am trying to figure out how to use a few basic path finding algorithms. Essentially, I have a collection of notes labelled LogisticalUnit, representing companies or locations that can ship goods to other places. Two such units can have a relationship SHIPS_TO with a property cost. Attempting to find a path with minimal cost to go from node A to B gives me a promising result using algo.shortestPath.stream:
match (startNode :LogisticalUnit {id: 2}), (endNode :LogisticalUnit {id: 5})
call algo.shortestPath.stream(startNode, endNode, 'cost', {direction: 'OUTGOING', nodeQuery: 'LogisticalUnit', relationshipQuery: 'SHIPS_TO'})
yield nodeId, cost
return *;
However, it turns out that if I have another relationship such as RECOMMENDS, and it has the cost property, it is considered as well. It seems the relationshipQuery config does not actually work. As a matter of fact, replacing the config with relationshipQuery: 'FOOBAR', while no such relationship even exists in my database, will still return the same result!
The nodeQuery property behaves as expected and if I change it to another label it will correctly dismiss the results.
Any idea where I'm going wrong here? Thanks a lot in advance.
neo4j cypher shortest-path
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
add a comment |
I am new to Neo4j and I am trying to figure out how to use a few basic path finding algorithms. Essentially, I have a collection of notes labelled LogisticalUnit, representing companies or locations that can ship goods to other places. Two such units can have a relationship SHIPS_TO with a property cost. Attempting to find a path with minimal cost to go from node A to B gives me a promising result using algo.shortestPath.stream:
match (startNode :LogisticalUnit {id: 2}), (endNode :LogisticalUnit {id: 5})
call algo.shortestPath.stream(startNode, endNode, 'cost', {direction: 'OUTGOING', nodeQuery: 'LogisticalUnit', relationshipQuery: 'SHIPS_TO'})
yield nodeId, cost
return *;
However, it turns out that if I have another relationship such as RECOMMENDS, and it has the cost property, it is considered as well. It seems the relationshipQuery config does not actually work. As a matter of fact, replacing the config with relationshipQuery: 'FOOBAR', while no such relationship even exists in my database, will still return the same result!
The nodeQuery property behaves as expected and if I change it to another label it will correctly dismiss the results.
Any idea where I'm going wrong here? Thanks a lot in advance.
neo4j cypher shortest-path
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
It is behaving as if you misspelled "relationshipQuery", but as far as I can tell, you spelled it correctly. I can't test if this is a bug. Is the Cypher you posted a direct copy-paste of what you executed?
– Tezra
Nov 21 '18 at 19:40
I did notice it's possible to add random configs and Cypher won't complain, so I considered it could have been a typo. I made sure to copypaste the name from the documentation. The Cypher query I posted is a direct copy-paste with only a change in the name of the node label and addition of newlines.
– Alex vdG
Nov 21 '18 at 19:55
add a comment |
I am new to Neo4j and I am trying to figure out how to use a few basic path finding algorithms. Essentially, I have a collection of notes labelled LogisticalUnit, representing companies or locations that can ship goods to other places. Two such units can have a relationship SHIPS_TO with a property cost. Attempting to find a path with minimal cost to go from node A to B gives me a promising result using algo.shortestPath.stream:
match (startNode :LogisticalUnit {id: 2}), (endNode :LogisticalUnit {id: 5})
call algo.shortestPath.stream(startNode, endNode, 'cost', {direction: 'OUTGOING', nodeQuery: 'LogisticalUnit', relationshipQuery: 'SHIPS_TO'})
yield nodeId, cost
return *;
However, it turns out that if I have another relationship such as RECOMMENDS, and it has the cost property, it is considered as well. It seems the relationshipQuery config does not actually work. As a matter of fact, replacing the config with relationshipQuery: 'FOOBAR', while no such relationship even exists in my database, will still return the same result!
The nodeQuery property behaves as expected and if I change it to another label it will correctly dismiss the results.
Any idea where I'm going wrong here? Thanks a lot in advance.
neo4j cypher shortest-path
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
I am new to Neo4j and I am trying to figure out how to use a few basic path finding algorithms. Essentially, I have a collection of notes labelled LogisticalUnit, representing companies or locations that can ship goods to other places. Two such units can have a relationship SHIPS_TO with a property cost. Attempting to find a path with minimal cost to go from node A to B gives me a promising result using algo.shortestPath.stream:
match (startNode :LogisticalUnit {id: 2}), (endNode :LogisticalUnit {id: 5})
call algo.shortestPath.stream(startNode, endNode, 'cost', {direction: 'OUTGOING', nodeQuery: 'LogisticalUnit', relationshipQuery: 'SHIPS_TO'})
yield nodeId, cost
return *;
However, it turns out that if I have another relationship such as RECOMMENDS, and it has the cost property, it is considered as well. It seems the relationshipQuery config does not actually work. As a matter of fact, replacing the config with relationshipQuery: 'FOOBAR', while no such relationship even exists in my database, will still return the same result!
The nodeQuery property behaves as expected and if I change it to another label it will correctly dismiss the results.
Any idea where I'm going wrong here? Thanks a lot in advance.
neo4j cypher shortest-path
neo4j cypher shortest-path
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
edited Nov 21 '18 at 19:19
Alex vdG
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
asked Nov 21 '18 at 19:17
Alex vdGAlex vdG
62
62
It is behaving as if you misspelled "relationshipQuery", but as far as I can tell, you spelled it correctly. I can't test if this is a bug. Is the Cypher you posted a direct copy-paste of what you executed?
– Tezra
Nov 21 '18 at 19:40
I did notice it's possible to add random configs and Cypher won't complain, so I considered it could have been a typo. I made sure to copypaste the name from the documentation. The Cypher query I posted is a direct copy-paste with only a change in the name of the node label and addition of newlines.
– Alex vdG
Nov 21 '18 at 19:55
add a comment |
It is behaving as if you misspelled "relationshipQuery", but as far as I can tell, you spelled it correctly. I can't test if this is a bug. Is the Cypher you posted a direct copy-paste of what you executed?
– Tezra
Nov 21 '18 at 19:40
I did notice it's possible to add random configs and Cypher won't complain, so I considered it could have been a typo. I made sure to copypaste the name from the documentation. The Cypher query I posted is a direct copy-paste with only a change in the name of the node label and addition of newlines.
– Alex vdG
Nov 21 '18 at 19:55
It is behaving as if you misspelled "relationshipQuery", but as far as I can tell, you spelled it correctly. I can't test if this is a bug. Is the Cypher you posted a direct copy-paste of what you executed?
– Tezra
Nov 21 '18 at 19:40
It is behaving as if you misspelled "relationshipQuery", but as far as I can tell, you spelled it correctly. I can't test if this is a bug. Is the Cypher you posted a direct copy-paste of what you executed?
– Tezra
Nov 21 '18 at 19:40
I did notice it's possible to add random configs and Cypher won't complain, so I considered it could have been a typo. I made sure to copypaste the name from the documentation. The Cypher query I posted is a direct copy-paste with only a change in the name of the node label and addition of newlines.
– Alex vdG
Nov 21 '18 at 19:55
I did notice it's possible to add random configs and Cypher won't complain, so I considered it could have been a typo. I made sure to copypaste the name from the documentation. The Cypher query I posted is a direct copy-paste with only a change in the name of the node label and addition of newlines.
– Alex vdG
Nov 21 '18 at 19:55
add a comment |
0
active
oldest
votes
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%2f53419108%2fneo4j-algo-shortestpath-with-only-certain-label-of-relationship%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53419108%2fneo4j-algo-shortestpath-with-only-certain-label-of-relationship%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
It is behaving as if you misspelled "relationshipQuery", but as far as I can tell, you spelled it correctly. I can't test if this is a bug. Is the Cypher you posted a direct copy-paste of what you executed?
– Tezra
Nov 21 '18 at 19:40
I did notice it's possible to add random configs and Cypher won't complain, so I considered it could have been a typo. I made sure to copypaste the name from the documentation. The Cypher query I posted is a direct copy-paste with only a change in the name of the node label and addition of newlines.
– Alex vdG
Nov 21 '18 at 19:55