Problem in challenge Adding or Updating a Movie - Cypher Fundamentals

[darciosavilela]

I believe the code is correct, but the system does not validate. I am stuck on this. Here is my code:
```

MERGE (m:Movie {title: 'Rocketman'})

ON MATCH SET m.matchedAt=datetime()

ON CREATE SET m.createdAt=datetime()

SET m.updatedAt=timestamp()

RETURN

m.title, m.matchedAt, m.createdAt, m.updatedAt

`

What is necessary to do?

Tks

[glilienfield]

The query executed in desktop. Can you send the question link? 

[darciosavilela]

Hi. Here is the link:

https://graphacademy.neo4j.com/courses/cypher-fundamentals/2-writing/8-c-merge-processing/

[glilienfield]

Did you run the query twice before validating it?  Here is the result I pulled from when I took the course:

/* First Run - only  createdAt and updatedAt will be set */
MERGE (m:Movie {title: 'Rocketman'})
/* perform the ON MATCH setting of the matchedAt property */
ON MATCH SET m.matchedAt = datetime()
/* perform the ON CREATE setting of the createdAt property */
ON CREATE SET m.createdAt = datetime()
/* set the updatedAt property */
SET m.updatedAt = timestamp()
RETURN m.title, m.createdAt, m.matchedAt, m.updatedAt;


/* Second Run - all three properties will be set */
MERGE (m:Movie {title: 'Rocketman'})
/* perform the ON MATCH setting of the matchedAt property */
ON MATCH SET m.matchedAt = datetime()
/* perform the ON CREATE setting of the createdAt property */
ON CREATE SET m.createdAt = datetime()
/* set the updatedAt property */
SET m.updatedAt = timestamp()
RETURN m.title, m.createdAt, m.matchedAt, m.updatedAt

[darciosavilela]

Yeah, I run twice. Then I logged out, logged in again and try several times. I know the query is ok, I just wanted to finish 100% of the course.

[glilienfield]

I understand.  I finished the course and what I posted was from my course.  Maybe try deleting your sandbox. It will be recreated when to start the class the next time. 

[darciosavilela]

Hi. I tried logout sandbox and login again with my database access and worked. Tks!

[elaine_rosenber]

Hello @darciosavilela ,

Do you see the $neo4j prompt in the sandbox pane on the right?

I am wondering if your Course is using the sandbox instance.

Elaine

[darciosavilela]

Hi, problem solved. I disconnected from my sandbox and logged in again.

tks