Hi folks,
I often pass in lists of data dictionaries in parameters and UNWIND them in the query to MERGE or CREATE nodes based on provided information. When I try to do it with two sets of data as separate parameters, if both are filled out with data...
Hi folks,
When I try to use apoc.temporal.format inside an OPTIONAL MATCH clause which returns no nodes, I get a Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke function 'apoc.temporal.format': Caused by: java.lang.NullPointerExceptio...
Hi, I always struggle to query/model things like this effectively:
match (a:A)-[:REL1]->(b:B)
where b.prop in range ( x, y )
and not (
(a)-[:REL2]->(c:C)
where c.start < $val < c.end
)
I know that construct/syntax isn't valid, but is there a...
Hi all, I'm working on updating from 3.1.x to 3.4.7 and preparing for 4.0. Quite a lot of work. It seems also that the browser no longer works just over HTTPS, I can no longer find the "don't use Bolt" option. We have quite a lot of infrastructure in...
Hi there, moving a conversation over from my 'intro' mail!
Hello from Igor Clark
No, we will maintain the /db/transactin/commit* endpoint for transactional cypher. the other one is not streaming.
Which is what all non-bolt drivers should use. Ca...
Morning Andrew, I just got this doing exactly what I need using apoc.do.when. I still can't believe I never came across this before, it's a game-changer for me. And cypher.doIt will certainly be very useful too. Thanks!
Will definitely keep an eye on...
Thanks for getting back to me so quickly Andrew!
Aha, yes, OPTIONAL UNWIND would be fantastic - I saw a proposal for it in my searching but it was from 2017 and it didn't seem to be ready. And I often use apoc.cypher.run to rationalize and clarify th...
Thank you both for your answers. @ameyasoft, I think that's the error I was wondering about, should this function just crash like this when presented with a NULL? Which is what @andrew.bowman was wondering in his response. Personally I think it would...
Hi Andrew, thanks very much! Didn't think of doing it that way round, that's very helpful.
Cypher updates sound good. It'll probably be a long time before we'll be able to move to 4.x as we'll have to rewrite swathes of application code due to the re...