How to filter the nodes in Neo4j using the relationship property that is of type List











up vote
1
down vote

favorite












How to retrieve all the influencers for a specific user and based on specific property in a relationship defined for example in the below example I want retrieve all the influencers for p1 in prid= 'c1' and projects IN only PR1?



Sample Data Set



 CREATE (p1:People {name:'P1 User',  id: 'p001'})

CREATE (p2:People {name:'P2 User',  id: 'p002'})

CREATE (p3:People {name:'P3 User',  id: 'p003'})

CREATE (p4:People {name:'P4 User',  id: 'p004'})

CREATE (p5:People {name:'P5 User',  id: 'p005'})



CREATE

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR2']}]-(p2),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR4']}]-(p3),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p4),

      (p2)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p3),

      (p3)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p4),

      (p4)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p5)



 MATCH (p:People{gsid:'p001'})<-[r:INFLUNCED_BY]-(:People)

    WHERE r.prid='c1' AND r.projects IN ['PR1']

    RETURN p,r;


The above query is returning no records even though the following relationships exists



MATCH (node) RETURN node;


The result for the above query






neo4j







share|improve this question
























  • How to create a Minimal, Complete, and Verifiable example: stackoverflow.com/help/mcve
    – stdob--
    yesterday










  • Please refer to the edit post
    – Naveen Kumar D C
    yesterday















up vote
1
down vote

favorite












How to retrieve all the influencers for a specific user and based on specific property in a relationship defined for example in the below example I want retrieve all the influencers for p1 in prid= 'c1' and projects IN only PR1?



Sample Data Set



 CREATE (p1:People {name:'P1 User',  id: 'p001'})

CREATE (p2:People {name:'P2 User',  id: 'p002'})

CREATE (p3:People {name:'P3 User',  id: 'p003'})

CREATE (p4:People {name:'P4 User',  id: 'p004'})

CREATE (p5:People {name:'P5 User',  id: 'p005'})



CREATE

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR2']}]-(p2),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR4']}]-(p3),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p4),

      (p2)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p3),

      (p3)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p4),

      (p4)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p5)



 MATCH (p:People{gsid:'p001'})<-[r:INFLUNCED_BY]-(:People)

    WHERE r.prid='c1' AND r.projects IN ['PR1']

    RETURN p,r;


The above query is returning no records even though the following relationships exists



MATCH (node) RETURN node;


The result for the above query






neo4j







share|improve this question
























  • How to create a Minimal, Complete, and Verifiable example: stackoverflow.com/help/mcve
    – stdob--
    yesterday










  • Please refer to the edit post
    – Naveen Kumar D C
    yesterday













up vote
1
down vote

favorite









up vote
1
down vote

favorite











How to retrieve all the influencers for a specific user and based on specific property in a relationship defined for example in the below example I want retrieve all the influencers for p1 in prid= 'c1' and projects IN only PR1?



Sample Data Set



 CREATE (p1:People {name:'P1 User',  id: 'p001'})

CREATE (p2:People {name:'P2 User',  id: 'p002'})

CREATE (p3:People {name:'P3 User',  id: 'p003'})

CREATE (p4:People {name:'P4 User',  id: 'p004'})

CREATE (p5:People {name:'P5 User',  id: 'p005'})



CREATE

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR2']}]-(p2),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR4']}]-(p3),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p4),

      (p2)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p3),

      (p3)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p4),

      (p4)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p5)



 MATCH (p:People{gsid:'p001'})<-[r:INFLUNCED_BY]-(:People)

    WHERE r.prid='c1' AND r.projects IN ['PR1']

    RETURN p,r;


The above query is returning no records even though the following relationships exists



MATCH (node) RETURN node;


The result for the above query






neo4j







share|improve this question















How to retrieve all the influencers for a specific user and based on specific property in a relationship defined for example in the below example I want retrieve all the influencers for p1 in prid= 'c1' and projects IN only PR1?



Sample Data Set



 CREATE (p1:People {name:'P1 User',  id: 'p001'})

CREATE (p2:People {name:'P2 User',  id: 'p002'})

CREATE (p3:People {name:'P3 User',  id: 'p003'})

CREATE (p4:People {name:'P4 User',  id: 'p004'})

CREATE (p5:People {name:'P5 User',  id: 'p005'})



CREATE

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR2']}]-(p2),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1','PR4']}]-(p3),

      (p1)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p4),

      (p2)<-[:INFLUENCER {prid:'c1', projects:['PR1']}]-(p3),

      (p3)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p4),

      (p4)<-[:INFLUENCER {prid:'c1', projects:['PR4','PR5']}]-(p5)



 MATCH (p:People{gsid:'p001'})<-[r:INFLUNCED_BY]-(:People)

    WHERE r.prid='c1' AND r.projects IN ['PR1']

    RETURN p,r;


The above query is returning no records even though the following relationships exists



MATCH (node) RETURN node;


The result for the above query






neo4j




neo4j






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited yesterday

























asked yesterday









Naveen Kumar D C

266




266












  • How to create a Minimal, Complete, and Verifiable example: stackoverflow.com/help/mcve
    – stdob--
    yesterday










  • Please refer to the edit post
    – Naveen Kumar D C
    yesterday


















  • How to create a Minimal, Complete, and Verifiable example: stackoverflow.com/help/mcve
    – stdob--
    yesterday










  • Please refer to the edit post
    – Naveen Kumar D C
    yesterday
















How to create a Minimal, Complete, and Verifiable example: stackoverflow.com/help/mcve
– stdob--
yesterday




How to create a Minimal, Complete, and Verifiable example: stackoverflow.com/help/mcve
– stdob--
yesterday












Please refer to the edit post
– Naveen Kumar D C
yesterday




Please refer to the edit post
– Naveen Kumar D C
yesterday












1 Answer
1






active

oldest

votes

















up vote
1
down vote













First, you do not have the same names for the properties of nodes and type of relationships in the query:



gsid vs id

INFLUNCED_BY vs INFLUENCER


Second, you need to check the intersection of the lists, not the occurrence. So according to the test data:



MATCH (p:People {id:'p001'})<-[r:INFLUENCER]-(:People)

WHERE r.prid ='c1' AND 

      // Check the lists for intersection

      any(p IN r.projects WHERE p IN ['PR1'])

RETURN p, r;





share|improve this answer





















    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














     

    draft saved


    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372606%2fhow-to-filter-the-nodes-in-neo4j-using-the-relationship-property-that-is-of-type%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    1
    down vote













    First, you do not have the same names for the properties of nodes and type of relationships in the query:



    gsid vs id
    
INFLUNCED_BY vs INFLUENCER


    Second, you need to check the intersection of the lists, not the occurrence. So according to the test data:



    MATCH (p:People {id:'p001'})<-[r:INFLUENCER]-(:People)
    
WHERE r.prid ='c1' AND 
    
      // Check the lists for intersection
    
      any(p IN r.projects WHERE p IN ['PR1'])
    
RETURN p, r;





    share|improve this answer

























      up vote
      1
      down vote













      First, you do not have the same names for the properties of nodes and type of relationships in the query:



      gsid vs id
      
INFLUNCED_BY vs INFLUENCER


      Second, you need to check the intersection of the lists, not the occurrence. So according to the test data:



      MATCH (p:People {id:'p001'})<-[r:INFLUENCER]-(:People)
      
WHERE r.prid ='c1' AND 
      
      // Check the lists for intersection
      
      any(p IN r.projects WHERE p IN ['PR1'])
      
RETURN p, r;





      share|improve this answer























        up vote
        1
        down vote










        up vote
        1
        down vote









        First, you do not have the same names for the properties of nodes and type of relationships in the query:



        gsid vs id
        
INFLUNCED_BY vs INFLUENCER


        Second, you need to check the intersection of the lists, not the occurrence. So according to the test data:



        MATCH (p:People {id:'p001'})<-[r:INFLUENCER]-(:People)
        
WHERE r.prid ='c1' AND 
        
      // Check the lists for intersection
        
      any(p IN r.projects WHERE p IN ['PR1'])
        
RETURN p, r;





        share|improve this answer












        First, you do not have the same names for the properties of nodes and type of relationships in the query:



        gsid vs id
        
INFLUNCED_BY vs INFLUENCER


        Second, you need to check the intersection of the lists, not the occurrence. So according to the test data:



        MATCH (p:People {id:'p001'})<-[r:INFLUENCER]-(:People)
        
WHERE r.prid ='c1' AND 
        
      // Check the lists for intersection
        
      any(p IN r.projects WHERE p IN ['PR1'])
        
RETURN p, r;






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered yesterday









        stdob--

        18.7k42948




        18.7k42948






























             

            draft saved


            draft discarded



















































             


            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372606%2fhow-to-filter-the-nodes-in-neo4j-using-the-relationship-property-that-is-of-type%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            'app-layout' is not a known element: how to share Component with different Modules

            Image
            0 My application was working fine until I decided to go with lazy loading: So, my shared component looks like this: import { Component, Renderer2 } from '@angular/core'; export interface FormModel { captcha?: string; } @Component({ selector: 'app-layout', templateUrl: './app-layout.component.html', styleUrls: ['./app-layout.css'] }) export class FullLayoutComponent { } app-layout.component.ts I am using this component in my Another component say school-home.component.html like this: <app-layout> </app-layout> and it was working fine until I created a Module school-home.module.ts like this: import { NgModule } from '@angular/core'; import { CommonModule } from '@angular/common'; import { SchoolhomeRoutingModule ...
            Read more

            android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 This is a simple project showing cubes on Unity, exported to android project and imported on Android studio. On maifest file it showed following warning: Expecting <uses-feature android:name="android.software.leanback" android:required="false" /> tag I have no information about it. And also on default emptyview android project does not use/mention this feature. I know it is required by TV's and such but why its not added by default? Why is this? And Should I concern about it? android unity3d ...
            Read more

            WPF add header to Image with URL pettitions [duplicate]

            Image
            up vote 0 down vote favorite This question already has an answer here: Image source URI requiring authorization 3 answers Add header to all* HTTP requests on a machine 1 answer first of all sorry for my english. Recently I added some security in the backend of my project, and now I need to send a validation code(apiKey) inside the headers to retrieve the images. I have a problem with ALL images in my project that I had attached in my UI. For example, before I had: <Image Height="90" Source="{Binding Video.Thumbnail}"/> Now I need to change my code to create a CUSTOM petition add the apiKey in the header:...
            Read more