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.
