 Neo4J / APOC - Cannot build query after calling stored procedure `apoc.cypher.doIt`
By : Nick M
Date : March 29 2020, 07:55 AM
it fixes the issue The issue here is that since the cypher executed in apoc.cypher.doIt() doesn't return any rows, YIELD yields nothing. You can confirm this by replacing your CREATE at the end with RETURN value: No changes, no records.
There are no rows to operate on, and all operations are performed per-row, so CREATE never gets executed, there are no rows to run it on.
|
 Neo4j: How to pass a variable to Neo4j Apoc (apoc.path.subgraphAll) Property
By : Mojtaba Sh
Date : March 29 2020, 07:55 AM
like below fixes the issue WIth some lead from cybersam's response, the below query gets me what I want. Only constraint is, this result is limited to 3 layers (3rd layer through Optional Match) code :
MATCH (TC:TBLCON) WHERE 'TBL3' IN TC.Tables
CALL apoc.path.subgraphAll(TC, {maxLevel:1}) YIELD nodes AS invN, relationships AS invR
WITH TC, REDUCE (tmpL=[], tmpr IN invR | tmpL+type(tmpr)) AS impR
MATCH FLP=(TC)-[]-()-[FLR]-(SL) WHERE type(FLR) IN impR
WITH FLP, TC, SL,impR
OPTIONAL MATCH SLP=(SL)-[SLR]-() WHERE type(SLR) IN impR RETURN FLP,SLP
MATCH (initTC:TBLCON) WHERE $TL IN initTC.Tables
WITH Reduce(O="",OO in Reduce (I=[], II in collect(apoc.node.relationship.types(initTC)) | I+II) | O+OO+"|") as RF
MATCH (TC:TBLCON) WHERE $TL IN TC.Tables
CALL apoc.path.subgraphAll(TC,{relationshipFilter:RF}) YIELD nodes, relationships
RETURN nodes, relationships
|
 Neo4j with APOC: running large CREATE in chunks using apoc.perodic.commit
By : Chris Griffin
Date : March 29 2020, 07:55 AM
wish help you to fix your issue Aside from the bug mentioned by @stdob--, you have a few additional major issues. You only have 8K locations but your periodic commit is using a limit of 10K, so it is not doing anything for you (except slowing you down even a bit more). So, if you tried using a lower limit (say, 1K or even 500), you might make some progress -- but it will still be slow. code :
(:Location {id: 123})-[:HAS_NAME]->(:LocName {name: 'Foo'})
(:Device {id: 765, ownedByLocName: 'Foo'})
CREATE INDEX ON :Device(ownedByLocName);
MATCH (loc:Location)
WHERE NOT (loc)-[:OWNS_DEVICE]->()
WITH loc LIMIT {limit}
MATCH (loc)-[:HAS_NAME]->(ln:LocName)
MATCH (dev:Device)
WHERE dev.ownedByLocName = ln.name
CREATE (loc)-[:OWNS_DEVICE {source:'Legacy Database'}]->(dev)
RETURN count(*)
|
Neo4j APOC assignedRelationshipProperties, removedRelationshipProperties triggers and apoc.index.in
By : user636915
Date : March 29 2020, 07:55 AM
wish help you to fix your issue The assignedRelationshipProperties is quite tricky. The structure of this parameter is Map >>.
Where, the first String is the key of the property, and the list elements are maps with the following keys : code :
CALL apoc.trigger.add('test-rel-trigger',
'UNWIND keys({assignedRelationshipProperties}) AS key
UNWIND {assignedRelationshipProperties}[key] AS map
WITH map WHERE type(map.relationship) = "HAS_VALUE_ON"
CALL apoc.index.addRelationship(map.relationship, keys(map.relationship)) RETURN count(*)'
, {phase:'before'})
|
neo4j/apoc: How to import a local HTML-file using apoc?
By : user3176337
Date : March 29 2020, 07:55 AM
I hope this helps you . Relative Path doesn't work in apoc.load.html. You need to provide the full path like: code :
CALL apoc.load.html("file:///<NEO4J_HOME>/import/Local.html",{metadata:"meta", h2:"title"})
|
» 
code :
Related Posts :