match (n)-[r1]->(p)-[r2]->(b:business) where id(n) = {otherUserId}
where r1.onPulse=true and r2.onPulse= true and (p:check_in OR p:tip OR p:review or p:rate) optional match (n)-[:pulse_post]->(pulse) optional match(p)-[r3:has_pix]->(pix:pix) OPTIONAL MATCH (p)-[tg:has_biz_tag|has_user_tag|has_hash_tag]->(tags) return n,r1,p,r2,r3,pix,tg,tags On Fri, Apr 7, 2017 at 9:20 AM, Alliance Ais <aistechnolabs....@gmail.com> wrote: > Hello Following My Neo4J Query to Get *CheckIn* or *Review* or *Pixel* > etc. which is Given by User to Business.Which I got perfectly.but *I want > also Get Pulse which given By User but not given on Business.* So My > Following Query is not Get Pulse. > > > <https://lh3.googleusercontent.com/-UbNvvKqhcPw/WOc9moX6piI/AAAAAAAAC8I/MiUDsXow51MiVJbvn_WCaiitZlaq9wy7gCLcB/s1600/pixelPost.jpg> > > start n=node({otherUserId}) with n match (n)-[r1]-(p)-[r2]-(b:business) > where r1.onPulse=true and r2.onPulse= true and ('check_in' IN labels(p) OR > 'tip' IN labels(p) OR 'review' IN labels(p) OR 'rate' IN labels(p)) with > p,r1,r2,n,b > optional match(p)-[r3:has_pix]-(pix:pix) > OPTIONAL MATCH (p)-[tg]-(tags) > where type(tg) in ['has_biz_tag', 'has_user_tag', 'has_hash_tag'] return > n,r1,p,r2,r3 > > Above my Relationship node. I want Neo4J Query for that. > > > Also I asked in StackOverflow : http://stackoverflow.com/q/ > 43271456/2893413 > > -- > 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 neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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 neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.