Neo4j

pjr4lph · 04-09-2020

I am trying to create/merge a node conditionally based on whether a variable does not equal the string 'Title'. I think I have 1 conditional node create working for when a variable value equals the string 'Title' but its hard to test without both wor...

pjr4lph · 06-24-2019

Hi, I am trying to query for all nodes of a specific type that do not have a specific property value, is this possible? MATCH (person:People)-[:NAME]->(name:Name) WHERE name.firstName = 'Sixto' IS NULL RETURN person or MATCH (person:People)-[:NAME]...

pjr4lph · 04-18-2019

Hi, currently i have about 30 grandchild (two connections deep from root) nodes that have values that are dates as isostrings and i need to wrap all of them with datetime(). i was thinking of querying for all of them, then re-saving them wrapped in d...

pjr4lph · 04-10-2020

ok! no more errors. the issue now is that the nodes and relationships are being created but they are blank. it seems that lines 2-6 are being ignored because the nodes that are appearing do not have any values or types.

pjr4lph · 04-10-2020

oh yes corrected, now getting the error: Invalid input ')': expected an identifier character, '.', whitespace, '(', node labels, '[', "=~", IN, STARTS, ENDS, CONTAINS, IS, '^', '*', '/', '%', '+', '-', '=', '~', "<>", "!=", '<', '>', "<=", ">=", AND...

pjr4lph · 04-10-2020

hhmmm still getting the same error Invalid input '|': expected whitespace, comment, '{', node labels, MapLiteral, a parameter, a relationship pattern, '(', '.', '[', "=~", IN, STARTS, ENDS, CONTAINS, IS, '^', '*', '/', '%', '+', '-', '=', '~', "<>", ...

pjr4lph · 04-10-2020

LOAD CSV WITH HEADERS FROM 'file:///v2/v2.csv' AS row WITH row.Region AS region, row.Regional_Coordinator_Title AS regionalCoordinatorTitle, FOREACH(ignoreMe IN CASE WHEN regionCoordinatorTitle <> 'Title' THEN [1] ELSE [] END | MERGE (rc:RegionCoord...

pjr4lph · 04-10-2020

@intouch.vivek right, i also saw Mark Needham's post, to use his code as an example: load csv with headers from "file:/tmp/foo.csv" as row MERGE (p:Person {a: row.a}) FOREACH(ignoreMe IN CASE WHEN trim(row.b) <> "" THEN [1] ELSE [] END | SET p.b = ro...

Neo4j

User Statistics

User Activity

Conditionally create or merge a node

Querying for nodes that do not have specific property values

How best to change all current isostring values to datetime with cypher

Re: Conditionally create or merge a node

Re: Conditionally create or merge a node

Re: Conditionally create or merge a node

Re: Conditionally create or merge a node

Re: Conditionally create or merge a node