<https://lh3.googleusercontent.com/-eDX3rqw_T3Y/WQBE4VCiZPI/AAAAAAAAC8o/tOrnfgJiIm4lYYxFBwj6UJcNW5zGExT9ACLcB/s1600/neo4j.jpg>
Hi, Michael Hunger
Thanks for reply and your query helped us a lot but little issue we have
that i am sharing with you please help us as we are near to complete
project as we stuck above requirement.
Let me explain where we are getting issue.
Please refer above image, while we are using your query we are getting
rate,review and tip but not getting pulse that is posted by system user,
while talking about pulse one important thing i would like to share with
you is pulse post done by user is not on venue[business]. where other
activities [check-in, review, tip, rate] done on venue[business] by user.
while using your query its not getting pulse in the result set.
One more thing in final result set that we are getting from your query ,
how we can set order by date in descending order for whole result set.
We are waiting for your suggestion that so valuable for us.
On Thursday, April 13, 2017 at 1:19:10 AM UTC+5:30, Michael Hunger wrote:
>
> 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 <[email protected]
> <javascript:>> 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 [email protected] <javascript:>.
>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
