Great help guys! I appreciate it.
On Sunday, April 20, 2014 5:44:57 PM UTC-4, Lundin wrote:
>
> What Mark said above or if you need to differantiate the user id into the
> collection (array in array) like:
>
> MATCH (n:User { uid:'Pontus Lundin' })-[:REL 1]-(m1), n-[:REL
> 2]-(m2),n-[:REL 3]-(m3)
> WITH n,collect(DISTINCT[m1.name,m2.name,m3.name]) AS group1
> MATCH n -[:REL4]-(m1)
> WITH group1,collect(m1.name) AS group2
> RETURN group1,group2
>
> You can continue building with with and match.
>
> Den söndagen den 20:e april 2014 kl. 21:33:09 UTC+2 skrev Alx:
>>
>> Lundin,
>>
>> Thanks for the reply. Basically I want to do what UNION (
>> http://docs.neo4j.org/chunked/stable/query-union.html) does exactly but
>> instead of stopping at the end of return continue with other queries. For
>> example something like this:
>>
>> MATCH (n:User{id:'1'} - [:REL1] - (m1) RETURN m1.id AS users
>> MATCH (n:User{id:'1'} - [:REL2] - (m2) RETURN m2.id AS users
>> MATCH (n:User{id:'1'} - [:REL3] - (m3) RETURN m3.id AS users
>>
>> Then collect the results like 'COLLECT (users) AS group1 ' because it is
>> meaningful that they are grouped together and then continue executing the
>> following queries:
>>
>> MATCH (n:User{id:'1'} - [:REL4] - (m4) WITH collect(m4.id) AS group 2 ,
>> MATCH (n:User{id:'1'} - [:REL5] - (m5) WITH collect(m5.id) AS group 3
>>
>> And finally return the collections:
>>
>> RETURN group1, group2, group3
>>
>>
>> I wonder if this is possible...
>>
>> Thanks a lot.
>>
>>
>>
>>
>> On Sunday, April 20, 2014 2:00:50 PM UTC-4, Lundin wrote:
>>>
>>> Alx.
>>>
>>> Wes Freeman wrote a blog post about OPTIONAL match, here:
>>> http://wes.skeweredrook.com/cypher-2-0-optional-match/
>>> At the bottom he explains the differences between using where before and
>>> after. Also limiting the questions before match seems logical so we dont
>>> have to match all users and then say but we are only intrested of user with
>>> a given property.
>>>
>>> For the question about removing duplicates, i have no answer for the
>>> result as it is now with two collections. But i fail to see how that
>>> output, the list make any sense other than for testing puropse. How do you
>>> delimit and know what belongs to what query ?
>>> What do you want from the query ?
>>>
>>> For me this one seems to fit a purpose:
>>>
>>> MATCH (n:User)
>>> WHERE HAS (n.uid)
>>> OPTIONAL
>>> MATCH (n)-[:LOCATED_IN]->()<-[:LOCATED_IN]-(m)
>>> WITH n,(m.name) AS users
>>> MATCH (n)-[:TEXTED]->(k)
>>> WHERE k.name<>users
>>> RETURN users,collect(k.name) AS texted_users,count(k.name) AS NoUserText
>>>
>>> This one list user that fullfulls the
>>> (n)-[:LOCATED_IN]->()<-[:LOCATED_IN]-(m) pattern and list them in the first
>>> column (from my perspective that is some kind of search of people that has
>>> no uid but is LOCATED_IN same as users with a uid).
>>> The next column lists all users where users with an uid has TEXTED to
>>> and removes the user in the first column (if he exists in the TEXTED list)
>>> (for me that is some kind of recommendation or analytic search)
>>>
>>> Of course you can add distinct to the various columns if a person has
>>> texted to the same user multiple times.
>>>
>>> You can also look into what UNION does for MATCH based queries as well.
>>>
>>>
>>> Den söndagen den 20:e april 2014 kl. 18:20:02 UTC+2 skrev Alx:
>>>>
>>>> Hi Lundin,
>>>>
>>>> Thanks for the elaborate response. I can understand your thinking and
>>>> it is helpful. The point is: what is it more efficient? a) To first find
>>>> users with uid and then try to optional match a pattern? b) Or try to
>>>> optional match the pattern and after that keep ('WHERE' command) only
>>>> those
>>>> results that users have uids?
>>>>
>>>>
>>>> I still have the question: how do I remove the duplicates from the
>>>> combined users1+ users2 list? Any suggestions?
>>>>
>>>>
>>>> On Saturday, April 19, 2014 11:23:29 PM UTC-4, Lundin wrote:
>>>>>
>>>>> Hi Alx,
>>>>>
>>>>> Most probably because your data/graph simply not fullful your total
>>>>> cypher statement, Remeber that your are matchning a pattern and you start
>>>>> with limiting it to users that has a uid property. For example the graph
>>>>> data below returns a resultset for each individually MATCH queries,
>>>>> however
>>>>> once chained, like your query, it fails to match that pattern. That is
>>>>> becuse there is no User that has uid property and other nodes that are
>>>>> connected via the LOCATED_IN (the cities they are living in)
>>>>> relationship,
>>>>> thus your query will return nil in the end.
>>>>>
>>>>> So with this graph data:
>>>>>
>>>>> CREATE (Pontus:User { uid:'Pontus Lundin',name:'Pontus Lundin'
>>>>> }),(John:User { uid: 'John Hellberg',name:'John Hellberg' }),(Jack:User {
>>>>> uid: 'Jack Hellberg',name:'Jack Hellberg' }),(Nisse:User { name: 'Nisse
>>>>> Larsson' }),(Kalle:User { name: 'Kalle Johansson' }),(Johan:User {
>>>>> name:'Johan Davidsson' }),(Ronny:User { name: 'Ronny Stork'
>>>>> }),(Micke:User
>>>>> { name: 'Mikael Jansson' }),(Anna:User { name: 'Anna Karlsson',
>>>>> sex:'female' }),(Sandra:User { name: 'Sandra Johansson', sex:'female'
>>>>> }),(Fredrik:User { name:'Fredrik Hansson' }),(Gothenburg:Location {
>>>>> name:'Gothenburg',dailyhits:1000000 }),(Stockholm:Location {
>>>>> name:'Stockholm',dailyhits:300000 }),(Sundsvall:Location {
>>>>> name:'Sundsvall',dailyhits:6000 }),(Malmo:Location {
>>>>> name:'Malmö',dailyhits:20000 }),
>>>>> (Pontus)-[:LOCATED_IN]->(Gothenburg),
>>>>> (Ronny)-[:LOCATED_IN]->(Sundsvall),
>>>>> (Sandra)-[:LOCATED_IN]->(Sundsvall),
>>>>> (Pontus)-[:TEXTED]->(Sandra),
>>>>> (Pontus)-[:TEXTED]->(Fredrik),
>>>>> (Jack)-[:LOCATED_IN]->(Malmo),
>>>>> (John)-[:LOCATED_IN]->(Stockholm),
>>>>> (Jack)-[:TEXTED]->(Pontus);
>>>>>
>>>>>
>>>>> This pattern will return data:
>>>>>
>>>>> MATCH (n:User)
>>>>> WHERE HAS (n.uid)
>>>>> return n;
>>>>>
>>>>>
>>>>> As well as:
>>>>> MATCH (n)-[:LOCATED_IN]->()<-[:LOCATED_IN]-(m),(n)-[:TEXTED]-(k)
>>>>> WITH COLLECT(DISTINCT m.name) AS users1, COLLECT(DISTINCT k.name) AS
>>>>> users2
>>>>> RETURN users1+ users2
>>>>>
>>>>> But not this chained Cypher query which return empty
>>>>>
>>>>> MATCH (n:User)
>>>>> WHERE HAS (n.uid)
>>>>> MATCH (n)-[:LOCATED_IN]->()<-[:LOCATED_IN]-(m),(n)-[:TEXTED]-(k)
>>>>> WITH COLLECT(DISTINCT m.name) AS users1, COLLECT(DISTINCT k.name) AS
>>>>> users2
>>>>> RETURN users1+ users2
>>>>>
>>>>>
>>>>> However if your data has connection that fullfulls your query then it
>>>>> works (now a User with uid lives in the same city as another node), like:
>>>>>
>>>>> CREATE (Pontus:User { uid:'Pontus Lundin',name:'Pontus Lundin'
>>>>> }),(John:User { uid: 'John Hellberg',name:'John Hellberg' }),(Jack:User {
>>>>> uid: 'Jack Hellberg',name:'Jack Hellberg' }),(Nisse:User { name: 'Nisse
>>>>> Larsson' }),(Kalle:User { name: 'Kalle Johansson' }),(Johan:User {
>>>>> name:'Johan Davidsson' }),(Ronny:User { name: 'Ronny Stork'
>>>>> }),(Micke:User
>>>>> { name: 'Mikael Jansson' }),(Anna:User { name: 'Anna Karlsson',
>>>>> sex:'female' }),(Sandra:User { name: 'Sandra Johansson', sex:'female'
>>>>> }),(Fredrik:User { name:'Fredrik Hansson' }),(Gothenburg:Location {
>>>>> name:'Gothenburg',dailyhits:1000000 }),(Stockholm:Location {
>>>>> name:'Stockholm',dailyhits:300000 }),(Sundsvall:Location {
>>>>> name:'Sundsvall',dailyhits:6000 }),(Malmo:Location {
>>>>> name:'Malmö',dailyhits:20000 }),
>>>>> (Pontus)-[:LOCATED_IN]->(Sundsvall),
>>>>> (Ronny)-[:LOCATED_IN]->(Sundsvall),
>>>>> (Sandra)-[:LOCATED_IN]->(Sundsvall),
>>>>> (Pontus)-[:TEXTED]->(Sandra),
>>>>> (Pontus)-[:TEXTED]->(Fredrik),
>>>>> (Jack)-[:LOCATED_IN]->(Malmo),
>>>>> (John)-[:LOCATED_IN]->(Stockholm),
>>>>> (Jack)-[:TEXTED]->(Pontus);
>>>>>
>>>>>
>>>>>
>>>>> If you still want to return *something* (if it makes sense for your
>>>>> result) event though the "match fails" you can use the OPTIONAL match
>>>>> like
>>>>> the one below:
>>>>>
>>>>> MATCH (n:User)
>>>>> WHERE HAS (n.uid)
>>>>> OPTIONAL
>>>>> MATCH (n)-[:LOCATED_IN]->()<-[:LOCATED_IN]-(m)
>>>>> WITH n,m
>>>>> MATCH (n)-[:TEXTED]-(k)
>>>>> WITH COLLECT(DISTINCT m.name) AS users1, COLLECT(DISTINCT k.name) AS
>>>>> users2
>>>>> RETURN users1+ users2
>>>>>
>>>>>
>>>>> Den söndagen den 20:e april 2014 kl. 02:00:33 UTC+2 skrev Alx:
>>>>>>
>>>>>> I have the following cypher query:
>>>>>>
>>>>>> MATCH (n:User) WHERE HAS(n.uid) MATCH
>>>>>> (n)-[:LOCATED_IN]->()<-[:LOCATED_IN]-(m), (n)-[:TEXTED]-(k) WITH
>>>>>> COLLECT
>>>>>> (DISTINCT m.name) AS users1, COLLECT( DISTINCT k.name )
>>>>>> AS users2 RETURN users1+ users2
>>>>>>
>>>>>> But it returns me no result. It just returns a title "users1+ users2".
>>>>>> I know that there are results in the query because I executed them
>>>>>> individually.
>>>>>>
>>>>>> My goal is to collect all the results from individual matches and
>>>>>> then count the distinct names. Thanks for the help in advance.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
--
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.
