Hi Dave,
Thanks for your appreciation and am glad to share my knowledge!
Thanks again,
-Kamal
On Wednesday, June 14, 2017 at 2:13:49 PM UTC-7, Dave Clissold wrote:
>
> Hey Kamal
>
> Thank you that worked!! I had guessed CASE was the way to go, but could
> not work out exactly where or how.
>
> I really appreciate your help.
>
> Regards
>
> Dave
>
> On Wednesday, 14 June 2017 07:19:45 UTC+1, Kamal Murthy wrote:
>>
>> 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.
