Hi David,
Try this:
MATCH (movie:Movie {id: 1})
OPTIONAL MATCH (me:User {id: 0})-[:SIMILAR]-(:User)-[rating:RATED]->(movie)
UNWIND (CASE WHEN rating.recommend IS NULL then [0] else rating.recommend
end) AS ids
OPTIONAL MATCH (related:Movie) WHERE related.id = ids
WITH DISTINCT movie, related, count(related) AS countRelated ORDER BY
countRelated DESC
RETURN DISTINCT movie,
CASE WHEN related.id IS NULL THEN null else
collect(DISTINCT {name:related.name, id:related.id, count:countRelated}) END
AS related;
This worked for me and displayed movie, Matrix.
If you change the RETURN statement to:
RETURN DISTINCT movie.name as Movie,
CASE WHEN related.id IS NULL THEN null else
collect(DISTINCT {name:related.name, id:related.id, count:countRelated}) END
AS related;
Result: Matrix, null
-Kamal
On Tuesday, June 13, 2017 at 4:58:48 PM UTC-7, Dave Clissold wrote:
>
> Have created the query and data in a console here
>
> http://console.neo4j.org/?id=y6ysgs
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
