Neo4j How to add multiple relationships with property filter of each relationship?
MATCH (me)-[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
In this case how can I check different 'status' of all 3 relations?
FOLLOWS_TEAM has accepted:1
FOLLOWS has accepted:1
FOLLOWS_EVENT dont have any status.
If I add like following, its not working for 'FOLLOWS_EVENT'
[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:EVENTS_OF_ORG*0..1{accepted:1}]
neo4j cypher
add a comment |
MATCH (me)-[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
In this case how can I check different 'status' of all 3 relations?
FOLLOWS_TEAM has accepted:1
FOLLOWS has accepted:1
FOLLOWS_EVENT dont have any status.
If I add like following, its not working for 'FOLLOWS_EVENT'
[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:EVENTS_OF_ORG*0..1{accepted:1}]
neo4j cypher
add a comment |
MATCH (me)-[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
In this case how can I check different 'status' of all 3 relations?
FOLLOWS_TEAM has accepted:1
FOLLOWS has accepted:1
FOLLOWS_EVENT dont have any status.
If I add like following, its not working for 'FOLLOWS_EVENT'
[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:EVENTS_OF_ORG*0..1{accepted:1}]
neo4j cypher
MATCH (me)-[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
In this case how can I check different 'status' of all 3 relations?
FOLLOWS_TEAM has accepted:1
FOLLOWS has accepted:1
FOLLOWS_EVENT dont have any status.
If I add like following, its not working for 'FOLLOWS_EVENT'
[post_rel_source:FOLLOWS_TEAM|:FOLLOWS|:EVENTS_OF_ORG*0..1{accepted:1}]
neo4j cypher
neo4j cypher
edited Jan 2 at 20:29
cybersam
40.5k53252
40.5k53252
asked Jan 2 at 15:12
AbhiAbhi
88851828
88851828
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
[EDITED]
This snippet should work:
...
MATCH (me)-[r:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
WHERE
SIZE(r) = 0 OR
TYPE(r[0]) = 'FOLLOWS_EVENT' OR
r[0].accepted = 1
...
Note: since your relationship pattern allows for a 0-length path (i.e., a path where me
and user
are the same node, and there is no matching relationship between them), the SIZE(r) = 0
test detects and accepts that case (which is presumably what you wanted).
Its showing error - Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Relationship but was List<Relationship> (line 2, column 34 (offset: 198)) WHERE TYPE(r)='FOLLOWS_EVENT'
– Abhi
Jan 3 at 13:39
OK, see if my updated answer works.
– cybersam
Jan 3 at 18:14
Awesome ... thank you so much
– Abhi
Jan 7 at 7:04
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%2f54008735%2fneo4j-how-to-add-multiple-relationships-with-property-filter-of-each-relationshi%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
[EDITED]
This snippet should work:
...
MATCH (me)-[r:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
WHERE
SIZE(r) = 0 OR
TYPE(r[0]) = 'FOLLOWS_EVENT' OR
r[0].accepted = 1
...
Note: since your relationship pattern allows for a 0-length path (i.e., a path where me
and user
are the same node, and there is no matching relationship between them), the SIZE(r) = 0
test detects and accepts that case (which is presumably what you wanted).
Its showing error - Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Relationship but was List<Relationship> (line 2, column 34 (offset: 198)) WHERE TYPE(r)='FOLLOWS_EVENT'
– Abhi
Jan 3 at 13:39
OK, see if my updated answer works.
– cybersam
Jan 3 at 18:14
Awesome ... thank you so much
– Abhi
Jan 7 at 7:04
add a comment |
[EDITED]
This snippet should work:
...
MATCH (me)-[r:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
WHERE
SIZE(r) = 0 OR
TYPE(r[0]) = 'FOLLOWS_EVENT' OR
r[0].accepted = 1
...
Note: since your relationship pattern allows for a 0-length path (i.e., a path where me
and user
are the same node, and there is no matching relationship between them), the SIZE(r) = 0
test detects and accepts that case (which is presumably what you wanted).
Its showing error - Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Relationship but was List<Relationship> (line 2, column 34 (offset: 198)) WHERE TYPE(r)='FOLLOWS_EVENT'
– Abhi
Jan 3 at 13:39
OK, see if my updated answer works.
– cybersam
Jan 3 at 18:14
Awesome ... thank you so much
– Abhi
Jan 7 at 7:04
add a comment |
[EDITED]
This snippet should work:
...
MATCH (me)-[r:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
WHERE
SIZE(r) = 0 OR
TYPE(r[0]) = 'FOLLOWS_EVENT' OR
r[0].accepted = 1
...
Note: since your relationship pattern allows for a 0-length path (i.e., a path where me
and user
are the same node, and there is no matching relationship between them), the SIZE(r) = 0
test detects and accepts that case (which is presumably what you wanted).
[EDITED]
This snippet should work:
...
MATCH (me)-[r:FOLLOWS_TEAM|:FOLLOWS|:FOLLOWS_EVENT*0..1]->(user)
WHERE
SIZE(r) = 0 OR
TYPE(r[0]) = 'FOLLOWS_EVENT' OR
r[0].accepted = 1
...
Note: since your relationship pattern allows for a 0-length path (i.e., a path where me
and user
are the same node, and there is no matching relationship between them), the SIZE(r) = 0
test detects and accepts that case (which is presumably what you wanted).
edited Jan 3 at 18:19
answered Jan 2 at 20:25
cybersamcybersam
40.5k53252
40.5k53252
Its showing error - Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Relationship but was List<Relationship> (line 2, column 34 (offset: 198)) WHERE TYPE(r)='FOLLOWS_EVENT'
– Abhi
Jan 3 at 13:39
OK, see if my updated answer works.
– cybersam
Jan 3 at 18:14
Awesome ... thank you so much
– Abhi
Jan 7 at 7:04
add a comment |
Its showing error - Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Relationship but was List<Relationship> (line 2, column 34 (offset: 198)) WHERE TYPE(r)='FOLLOWS_EVENT'
– Abhi
Jan 3 at 13:39
OK, see if my updated answer works.
– cybersam
Jan 3 at 18:14
Awesome ... thank you so much
– Abhi
Jan 7 at 7:04
Its showing error - Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Relationship but was List<Relationship> (line 2, column 34 (offset: 198)) WHERE TYPE(r)='FOLLOWS_EVENT'
– Abhi
Jan 3 at 13:39
Its showing error - Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Relationship but was List<Relationship> (line 2, column 34 (offset: 198)) WHERE TYPE(r)='FOLLOWS_EVENT'
– Abhi
Jan 3 at 13:39
OK, see if my updated answer works.
– cybersam
Jan 3 at 18:14
OK, see if my updated answer works.
– cybersam
Jan 3 at 18:14
Awesome ... thank you so much
– Abhi
Jan 7 at 7:04
Awesome ... thank you so much
– Abhi
Jan 7 at 7:04
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%2f54008735%2fneo4j-how-to-add-multiple-relationships-with-property-filter-of-each-relationshi%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