Hi, I do not know your complete data model, but from your query I created a sample.
Here is my script: CREATE (u:SQL_Query) CREATE (c:from_SQL {from_sql: "user_view_status_logs"}) CREATE (u)-[:FROM]->(c) CREATE (c2:select_SQL {select_query: "(1) AS a"}) CREATE (u)-[:SELECT]->(c2) CREATE (c3:where_SQL {select_query: "(user_view_status_logs.event_id = 86 AND user_view_status_logs.user_id = 35 AND user_view_status_logs.log_type = Program) LIMIT"}) CREATE (u)-[:WHERE]->(c3) CREATE (c4:where_value_data {user_view_status_logs_user_id: 35, user_view_status_logs_event_id: 88}) CREATE (c3)-[:HAS]->(c4) CREATE (c5:where_value_data {user_view_status_logs_user_id: 35, user_view_status_logs_event_id: 86}) CREATE (c3)-[:HAS]->(c5) CREATE (c6:where_value_data {user_view_status_logs_user_id: 33, user_view_status_logs_event_id: 87}) CREATE (c3)-[:HAS]->(c6); <https://lh3.googleusercontent.com/-QBlMdjHfZLo/WpBfIt2PjCI/AAAAAAAACVU/fL6auUey08sdcK4-QLN_3ttCOsWjSIyKgCLcBGAs/s1600/kchan_2.PNG> Here I have included 'user_view_status_logs_user_id' and 'user_view_status_logs_event_id' properties in the same where_value_data node. You can have these properties in two different properties one in each where_value_data node. It should still work. MATCH (u:SQL_Query)-[:FROM]->(c:from_SQL), (u)-[:SELECT]->(c2:select_SQL) ,(u)-[:WHERE]->(c3:where_SQL)-[:HAS]->(c4:where_value_data) WHERE c4.user_view_status_logs_user_id = 35 AND c4.user_view_status_logs_event_id= 86 RETURN u,c, c2, c3,c4; <https://lh3.googleusercontent.com/-Rim59pnxmIw/WpBfcVXX0kI/AAAAAAAACVY/8wiGbDnJBr4oSEf05WOXDjXdQwXeNcOHQCLcBGAs/s1600/kchan_1.PNG> MATCH (u:SQL_Query)-[:FROM]->(c:from_SQL), (u)-[:SELECT]->(c2:select_SQL) ,(u)-[:WHERE]->(c3:where_SQL)-[:HAS]->(c4:where_value_data) WHERE c4.user_view_status_logs_user_id = 33 OR c4.user_view_status_logs_event_id= 86 RETURN u,c, c2, c3,c4; <https://lh3.googleusercontent.com/-JTNuCSWAOpk/WpBfjVIkkhI/AAAAAAAACVc/bwEIonJ3YHQs-C-H1e6LS-j3np8d2lXSACLcBGAs/s1600/kchan_3.PNG> Hope this will help you. -Kamal On Thursday, February 22, 2018 at 9:20:15 AM UTC-8, kchan...@gmail.com wrote: > > > <https://lh3.googleusercontent.com/-sdeZmzNKucA/Wo6S0qAyHZI/AAAAAAAAAAM/Xl7U6_-WMk4swMcWAieCnW7gb-1ihBPWgCLcBGAs/s1600/matched_graph.png> > > I have a large graph I need to find exact graph. > My match query is : > MATCH (u:SQL_Query)-[:FROM]->(c:from_SQL), (u)-[:SELECT]->(c2:select_SQL) > ,(u)-[:WHERE]->(c3:where_SQL) ,(v:where_SQL)-[:HAS]->(c4:where_value_data) > WHERE (c.from_sql IN [' user_view_status_logs ']) AND (c2.select_query IN > [' (1) AS a ']) AND (c3.select_query IN [' (user_view_status_logs.event_id > = 86 AND user_view_status_logs.user_id = 35 AND > user_view_status_logs.log_type = Program) LIMIT ']) AND (c4.where_value IN > [' user_view_status_logs.user_id = 35 ',' user_view_status_logs.event_id = > 86 ' ]) > RETURN u > > I got the graph it works given above in attachment():- > > Issue:- > My issue is number of node connected is 3 but i ask for only 2 with value. > IN function does not match exactly. > > > -- 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.