Re: [Neo4j] Match the node on the basis of properties values

2018-02-22 Thread kchandanssm


My concern is something different I am getting wrong graph on Match only I 
want that graph who only satisfy my condition not more than that like I 
want that graph who have only two node connected with where_SQL(Label) but 
I am getting three node connected to where_SQL Label.

-- 
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.


Re: [Neo4j] Match the node on the basis of properties values

2018-02-22 Thread 'Michael Hunger' via Neo4j
You only returned `u` so a single node
if you then double click that it expands all the connected data.

If you want to return your query results do `RETURN *`



On Thu, Feb 22, 2018 at 11:04 AM,  wrote:

>
> 
>
> 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.
>

-- 
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.


[Neo4j] Match the node on the basis of properties values

2018-02-22 Thread kchandanssm




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.