I have a graph that has
Users who can have
Posts that can tag
Tags and also have
I'm trying to return all posts that have ratings where both "Post" and the "Tags" are distinct.
So I tried something (and many variations of) this:
MATCH (this)-[:WROTE]->(post:Post)-[:HAS_RATING]->(rating:Rating) MATCH (post)-[:TAGGED]-(t:Tag) WITH DISTINCT t, post RETURN DISTINCT post, ORDER BY post.date DESC
But it's not working. Essentially I'll get responses where you'll find different posts that each tag the same
So now I'm trying to figure out how to return distinct posts where across all posts no single
Tag is every returned twice.
Would anybody have any thoughts on this one? Would be greatly appreciated!