On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

> Hi,

> I am using below query to get all possible paths between two nodes:

> START a=node:node_auto_index(name="A") , m=node:node_auto_index(name="M") MATCH p
> =a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR r.value=0) )RETURN p ORDER BY length
> (p) desc limit 20

> This query returns the results with loops as well i.e. paths contains
> loop. How can I restrict  this to return only simple paths.

> Br ,

> Rehan

On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan.az...@gmail.com> wrote:
> UpDate:

> My Nodes have multiple relationships of same type with each other.

> On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

>> Hi,

>> I am using below query to get all possible paths between two nodes:

>> START a=node:node_auto_index(name="A") , m=node:node_auto_index(name="M")
>> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR r.value=0)
>> ) RETURN p ORDER BY length(p) desc limit 20

>> This query returns the results with loops as well i.e. paths contains
>> loop. How can I restrict  this to return only simple paths.

>> Br ,

>> Rehan

> --

peter.neuba...@neotechnology.com> wrote:
> You could for instance exclude paths that have m or a as one of the
> nodes?
> http://docs.neo4j.org/chunked/snapshot/query-function.html#_collectio...

> Let me know if you need an example, I think I can craft one ...

> Cheers,

> /peter neubauer

> G:  neubauer.peter
> S:  peter.neubauer
> P:  +46 704 106975
> L:   http://www.linkedin.com/in/neubauer
> T:   @peterneubauer

> Neo4j 1.8 GA -
> http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html

> On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan.az...@gmail.com> wrote:
> > UpDate:

> > My Nodes have multiple relationships of same type with each other.

> > On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

> >> Hi,

> >> I am using below query to get all possible paths between two nodes:

> >> START a=node:node_auto_index(name="A") ,
> m=node:node_auto_index(name="M")
> >> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR
> r.value=0)
> >> ) RETURN p ORDER BY length(p) desc limit 20

> >> This query returns the results with loops as well i.e. paths contains
> >> loop. How can I restrict  this to return only simple paths.

> >> Br ,

> >> Rehan

> > --

> --

On Tue, Oct 9, 2012 at 11:26 PM, Rehan Azher <rehan.az...@gmail.com> wrote:
> Hi Peter,

> Can you help t craft one such query. please.

> Thanks and Best Regards,

> --
> Rehan Azher
> Cell: +65 92967887

> On Tue, Oct 9, 2012 at 10:38 PM, Peter Neubauer <
> peter.neuba...@neotechnology.com> wrote:

>> You could for instance exclude paths that have m or a as one of the
>> nodes?
>> http://docs.neo4j.org/chunked/snapshot/query-function.html#_collectio...

>> Let me know if you need an example, I think I can craft one ...

>> Cheers,

>> /peter neubauer

>> G:  neubauer.peter
>> S:  peter.neubauer
>> P:  +46 704 106975
>> L:   http://www.linkedin.com/in/neubauer
>> T:   @peterneubauer

>> Neo4j 1.8 GA -
>> http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html

>> On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan.az...@gmail.com> wrote:
>> > UpDate:

>> > My Nodes have multiple relationships of same type with each other.

>> > On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

>> >> Hi,

>> >> I am using below query to get all possible paths between two nodes:

>> >> START a=node:node_auto_index(name="A") ,
>> m=node:node_auto_index(name="M")
>> >> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR
>> r.value=0)
>> >> ) RETURN p ORDER BY length(p) desc limit 20

>> >> This query returns the results with loops as well i.e. paths contains
>> >> loop. How can I restrict  this to return only simple paths.

>> >> Br ,

>> >> Rehan

>> > --

>> --

>  --

On Wednesday, 10 October 2012 15:54:44 UTC+8, Wes Freeman wrote:

> This is a bit of an abomination--there should be a better way--but you
> might be able to use it to get simple paths:

> http://console.neo4j.org/r/1jiuaf

> If you want to see the cyclic paths, take out the where clause.

> Wes

> On Tue, Oct 9, 2012 at 11:26 PM, Rehan Azher <rehan...@gmail.com<javascript:>
> > wrote:

>> Hi Peter,

>> Can you help t craft one such query. please.

>> Thanks and Best Regards,

>> --
>> Rehan Azher
>> Cell: +65 92967887

>> On Tue, Oct 9, 2012 at 10:38 PM, Peter Neubauer <
>> peter.n...@neotechnology.com <javascript:>> wrote:

>>> You could for instance exclude paths that have m or a as one of the
>>> nodes?
>>> http://docs.neo4j.org/chunked/snapshot/query-function.html#_collectio...

>>> Let me know if you need an example, I think I can craft one ...

>>> Cheers,

>>> /peter neubauer

>>> G:  neubauer.peter
>>> S:  peter.neubauer
>>> P:  +46 704 106975
>>> L:   http://www.linkedin.com/in/neubauer
>>> T:   @peterneubauer

>>> Neo4j 1.8 GA -
>>> http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html

>>> On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan...@gmail.com <javascript:>>
>>> wrote:
>>> > UpDate:

>>> > My Nodes have multiple relationships of same type with each other.

>>> > On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

>>> >> Hi,

>>> >> I am using below query to get all possible paths between two nodes:

>>> >> START a=node:node_auto_index(name="A") ,
>>> m=node:node_auto_index(name="M")
>>> >> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR
>>> r.value=0)
>>> >> ) RETURN p ORDER BY length(p) desc limit 20

>>> >> This query returns the results with loops as well i.e. paths contains
>>> >> loop. How can I restrict  this to return only simple paths.

>>> >> Br ,

>>> >> Rehan

>>> > --

>>> --

>>  --

On Wed, Oct 10, 2012 at 11:43 PM, Rehan <rehan.az...@gmail.com> wrote:

> Thanks WES, what if we want to add a filter on relationship as well. i.e.
> property with value <=200.

> On Wednesday, 10 October 2012 15:54:44 UTC+8, Wes Freeman wrote:

>> This is a bit of an abomination--there should be a better way--but you
>> might be able to use it to get simple paths:

>> http://console.neo4j.org/r/**1jiuaf <http://console.neo4j.org/r/1jiuaf>

>> If you want to see the cyclic paths, take out the where clause.

>> Wes

>> On Tue, Oct 9, 2012 at 11:26 PM, Rehan Azher <rehan...@gmail.com> wrote:

>>> Hi Peter,

>>> Can you help t craft one such query. please.

>>> Thanks and Best Regards,

>>> --
>>> Rehan Azher
>>> Cell: +65 92967887

>>> On Tue, Oct 9, 2012 at 10:38 PM, Peter Neubauer <
>>> peter.n...@neotechnology.**com> wrote:

>>>>  You could for instance exclude paths that have m or a as one of the
>>>> nodes? http://docs.neo4j.org/chunked/**snapshot/query-function.html#_**
>>>> collection_functions<http://docs.neo4j.org/chunked/snapshot/query-function.html#_collectio...>

>>>> Let me know if you need an example, I think I can craft one ...

>>>> Cheers,

>>>> /peter neubauer

>>>> G:  neubauer.peter
>>>> S:  peter.neubauer
>>>> P:  +46 704 106975
>>>> L:   http://www.linkedin.com/in/**neubauer<http://www.linkedin.com/in/neubauer>
>>>> T:   @peterneubauer

>>>> Neo4j 1.8 GA - http://www.dzone.com/links/**
>>>> neo4j_18_release_fluent_graph_**literacy.html<http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html>

>>>> On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan...@gmail.com> wrote:
>>>> > UpDate:

>>>> > My Nodes have multiple relationships of same type with each other.

>>>> > On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

>>>> >> Hi,

>>>> >> I am using below query to get all possible paths between two nodes:

>>>> >> START a=node:node_auto_index(name="**A") ,
>>>> m=node:node_auto_index(name="**M")
>>>> >> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR
>>>> r.value=0)
>>>> >> ) RETURN p ORDER BY length(p) desc limit 20

>>>> >> This query returns the results with loops as well i.e. paths contains
>>>> >> loop. How can I restrict  this to return only simple paths.

>>>> >> Br ,

>>>> >> Rehan

>>>> > --

>>>> --

>>>  --

>>  --

On Thursday, 11 October 2012 17:07:34 UTC+8, Wes Freeman wrote:

> You could add that in to the WHERE clause with an AND, just like you had
> it in the original query.

> Wes

> On Wed, Oct 10, 2012 at 11:43 PM, Rehan <rehan...@gmail.com <javascript:>>wrote:

>> Thanks WES, what if we want to add a filter on relationship as well. i.e.
>> property with value <=200.

>> On Wednesday, 10 October 2012 15:54:44 UTC+8, Wes Freeman wrote:

>>> This is a bit of an abomination--there should be a better way--but you
>>> might be able to use it to get simple paths:

>>> http://console.neo4j.org/r/**1jiuaf <http://console.neo4j.org/r/1jiuaf>

>>> If you want to see the cyclic paths, take out the where clause.

>>> Wes

>>> On Tue, Oct 9, 2012 at 11:26 PM, Rehan Azher <rehan...@gmail.com> wrote:

>>>> Hi Peter,

>>>> Can you help t craft one such query. please.

>>>> Thanks and Best Regards,

>>>> --
>>>> Rehan Azher
>>>> Cell: +65 92967887

>>>> On Tue, Oct 9, 2012 at 10:38 PM, Peter Neubauer <
>>>> peter.n...@neotechnology.**com> wrote:

>>>>>  You could for instance exclude paths that have m or a as one of the
>>>>> nodes? http://docs.neo4j.org/chunked/**snapshot/query-function.html#_*
>>>>> *collection_functions<http://docs.neo4j.org/chunked/snapshot/query-function.html#_collectio...>

>>>>> Let me know if you need an example, I think I can craft one ...

>>>>> Cheers,

>>>>> /peter neubauer

>>>>> G:  neubauer.peter
>>>>> S:  peter.neubauer
>>>>> P:  +46 704 106975
>>>>> L:   http://www.linkedin.com/in/**neubauer<http://www.linkedin.com/in/neubauer>
>>>>> T:   @peterneubauer

>>>>> Neo4j 1.8 GA - http://www.dzone.com/links/**
>>>>> neo4j_18_release_fluent_graph_**literacy.html<http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html>

>>>>> On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan...@gmail.com> wrote:
>>>>> > UpDate:

>>>>> > My Nodes have multiple relationships of same type with each other.

>>>>> > On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

>>>>> >> Hi,

>>>>> >> I am using below query to get all possible paths between two nodes:

>>>>> >> START a=node:node_auto_index(name="**A") ,
>>>>> m=node:node_auto_index(name="**M")
>>>>> >> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR
>>>>> r.value=0)
>>>>> >> ) RETURN p ORDER BY length(p) desc limit 20

>>>>> >> This query returns the results with loops as well i.e. paths
>>>>> contains
>>>>> >> loop. How can I restrict  this to return only simple paths.

>>>>> >> Br ,

>>>>> >> Rehan

>>>>> > --

>>>>> --

>>>>  --

>>>  --

On Thu, Oct 11, 2012 at 9:46 PM, Rehan <rehan.az...@gmail.com> wrote:
> Hi Wes,

> Thank you .

> One more query is it possible to build a query which should not include a
> given path .

> Thanks and Best Regards,

> Rehan

> On Thursday, 11 October 2012 17:07:34 UTC+8, Wes Freeman wrote:

>> You could add that in to the WHERE clause with an AND, just like you had
>> it in the original query.

>> Wes

>> On Wed, Oct 10, 2012 at 11:43 PM, Rehan <rehan...@gmail.com> wrote:

>>> Thanks WES, what if we want to add a filter on relationship as well.
>>> i.e. property with value <=200.

>>> On Wednesday, 10 October 2012 15:54:44 UTC+8, Wes Freeman wrote:

>>>> This is a bit of an abomination--there should be a better way--but you
>>>> might be able to use it to get simple paths:

>>>> http://console.neo4j.org/r/**1ji**uaf<http://console.neo4j.org/r/1jiuaf>

>>>> If you want to see the cyclic paths, take out the where clause.

>>>> Wes

>>>> On Tue, Oct 9, 2012 at 11:26 PM, Rehan Azher <rehan...@gmail.com>wrote:

>>>>> Hi Peter,

>>>>> Can you help t craft one such query. please.

>>>>> Thanks and Best Regards,

>>>>> --
>>>>> Rehan Azher
>>>>> Cell: +65 92967887

>>>>> On Tue, Oct 9, 2012 at 10:38 PM, Peter Neubauer <
>>>>> peter.n...@neotechnology.**com> wrote:

>>>>>>  You could for instance exclude paths that have m or a as one of the
>>>>>> nodes? http://docs.neo4j.org/chunked/****
>>>>>> snapshot/query-function.html#_****collection_functions<http://docs.neo4j.org/chunked/snapshot/query-function.html#_collectio...>

>>>>>> Let me know if you need an example, I think I can craft one ...

>>>>>> Cheers,

>>>>>> /peter neubauer

>>>>>> G:  neubauer.peter
>>>>>> S:  peter.neubauer
>>>>>> P:  +46 704 106975
>>>>>> L:   http://www.linkedin.com/in/**neu**bauer<http://www.linkedin.com/in/neubauer>
>>>>>> T:   @peterneubauer

>>>>>> Neo4j 1.8 GA - http://www.dzone.com/links/**neo**
>>>>>> 4j_18_release_fluent_graph_**lit**eracy.html<http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html>

>>>>>> On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan...@gmail.com> wrote:
>>>>>> > UpDate:

>>>>>> > My Nodes have multiple relationships of same type with each other.

>>>>>> > On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

>>>>>> >> Hi,

>>>>>> >> I am using below query to get all possible paths between two nodes:

>>>>>> >> START a=node:node_auto_index(name="**A**") ,
>>>>>> m=node:node_auto_index(name="**M**")
>>>>>> >> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR
>>>>>> r.value=0)
>>>>>> >> ) RETURN p ORDER BY length(p) desc limit 20

>>>>>> >> This query returns the results with loops as well i.e. paths
>>>>>> contains
>>>>>> >> loop. How can I restrict  this to return only simple paths.

>>>>>> >> Br ,

>>>>>> >> Rehan

>>>>>> > --

>>>>>> --

>>>>>  --

>>>>  --

>>  --

On Thu, Oct 11, 2012 at 10:11 PM, Wes Freeman <freeman....@gmail.com> wrote:
> Probably. The question is, how do you know which path you don't want to
> include?

> On Thu, Oct 11, 2012 at 9:46 PM, Rehan <rehan.az...@gmail.com> wrote:

>> Hi Wes,

>> Thank you .

>> One more query is it possible to build a query which should not include a
>> given path .

>> Thanks and Best Regards,

>> Rehan

>> On Thursday, 11 October 2012 17:07:34 UTC+8, Wes Freeman wrote:

>>> You could add that in to the WHERE clause with an AND, just like you had
>>> it in the original query.

>>> Wes

>>> On Wed, Oct 10, 2012 at 11:43 PM, Rehan <rehan...@gmail.com> wrote:

>>>> Thanks WES, what if we want to add a filter on relationship as well.
>>>> i.e. property with value <=200.

>>>> On Wednesday, 10 October 2012 15:54:44 UTC+8, Wes Freeman wrote:

>>>>> This is a bit of an abomination--there should be a better way--but you
>>>>> might be able to use it to get simple paths:

>>>>> http://console.neo4j.org/r/**1ji**uaf<http://console.neo4j.org/r/1jiuaf>

>>>>> If you want to see the cyclic paths, take out the where clause.

>>>>> Wes

>>>>> On Tue, Oct 9, 2012 at 11:26 PM, Rehan Azher <rehan...@gmail.com>wrote:

>>>>>> Hi Peter,

>>>>>> Can you help t craft one such query. please.

>>>>>> Thanks and Best Regards,

>>>>>> --
>>>>>> Rehan Azher
>>>>>> Cell: +65 92967887

>>>>>> On Tue, Oct 9, 2012 at 10:38 PM, Peter Neubauer <
>>>>>> peter.n...@neotechnology.**com> wrote:

>>>>>>>  You could for instance exclude paths that have m or a as one of the
>>>>>>> nodes? http://docs.neo4j.org/chunked/****
>>>>>>> snapshot/query-function.html#_****collection_functions<http://docs.neo4j.org/chunked/snapshot/query-function.html#_collectio...>

>>>>>>> Let me know if you need an example, I think I can craft one ...

>>>>>>> Cheers,

>>>>>>> /peter neubauer

>>>>>>> G:  neubauer.peter
>>>>>>> S:  peter.neubauer
>>>>>>> P:  +46 704 106975
>>>>>>> L:   http://www.linkedin.com/in/**neu**bauer<http://www.linkedin.com/in/neubauer>
>>>>>>> T:   @peterneubauer

>>>>>>> Neo4j 1.8 GA - http://www.dzone.com/links/**neo**
>>>>>>> 4j_18_release_fluent_graph_**lit**eracy.html<http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html>

>>>>>>> On Tue, Oct 9, 2012 at 12:20 PM, Rehan <rehan...@gmail.com> wrote:
>>>>>>> > UpDate:

>>>>>>> > My Nodes have multiple relationships of same type with each other.

>>>>>>> > On Tuesday, 9 October 2012 18:15:25 UTC+8, Rehan wrote:

>>>>>>> >> Hi,

>>>>>>> >> I am using below query to get all possible paths between two
>>>>>>> nodes:

>>>>>>> >> START a=node:node_auto_index(name="**A**") ,
>>>>>>> m=node:node_auto_index(name="**M**")
>>>>>>> >> MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR
>>>>>>> r.value=0)
>>>>>>> >> ) RETURN p ORDER BY length(p) desc limit 20

>>>>>>> >> This query returns the results with loops as well i.e. paths
>>>>>>> contains
>>>>>>> >> loop. How can I restrict  this to return only simple paths.

>>>>>>> >> Br ,

>>>>>>> >> Rehan

>>>>>>> > --

>>>>>>> --

>>>>>>  --

>>>>>  --

>>>  --