Hi, I want to use object of relation for multiple relations, how to do that in the highlighted line below:
MATCH (genre:Genre)-[:HAS_CHANNEL]->(channel:Channel)-[:HAS_PROGRAM]->(program:Program)-[:HAS_SUBSCRIBER_JOINED]->(subscriber:Subscriber), (totalViewTime:TotalViewTime), (subscriber)-[genderRelation:HAS_PROGRAM_GENDER]->(gender:Gender)- [relationTotalViewTime:HAS_PROGRAM_TOTAL_VIEW_TIME]->(totalViewTime), (subscriber)-[ageGroupRelation:HAS_PROGRAM_AGE_GROUP]->(ageGroup:AgeGroup)- [relationTotalViewTime]->(totalViewTime) WHERE channel.name IN ["hollywood on", "chowtime on"] AND (channel.date >= "2014-02-02" AND channel.date <= "2015-02-02") AND program.programId=relationGenderTotalViewTime.programId RETURN DISTINCT relationTotalViewTime.date AS date, program.duration AS programDuration, totalViewTime.duration AS viewDuration, channel.serviceId AS serviceId, relationTotalViewTime.reach AS reach ORDER BY date; Please help !! -Sukaant Chaudhary <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479> -- 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.
