Re: Cypher : Getting all nodes which have a property

[dn]

Ahh, think I worked it out.

Adding all nodes that I create to an index such as "MYINDEX" with property "myProp" as some value, and then in the Cypher query I search through the index

START n=node:MYINDEX(myProp="myValue") RETURN n

[Peter Neubauer]

That's it.

/peter

Send from mobile.

[Jim Webber]

Hi Andy,

I think what you're outlining is a little bit tricky in Cypher right now. It's easy to solve by indexing those nodes that have a particular key, and then subsequently filtering that in Cypher. But setting that up solely in Cypher today isn't possible - you'll need to dip into another API (REST, Java) to do the indexing bit.

FWIW the team will be sorting out auto indexes and making them on a par with regular indexes soon enough, and once that's done it opens the way for Cypher to deliver the index operations you're looking for. But that won't be in the 1.8 release.

Jim

[Shelley Tong]

If I didn't create an index, how do I execute the same query?

If that's not possible, how do I create an index to my already existing nodes and relationships?

Shelley

[Rodger]

Shelly, without auto_indexes, you can use the has () clause

START n=node(*) 

WHERE has (n.myProp)

and n.myProp="someValue"

RETURN n

In my experience, has () must be on the first line in the WHERE clause,

otherwise you will get the error that the node(0) does not have the property.

HTH

[Rodger]

In Version 2, you can also filter on the Label, using this syntax:

start n=node(*)

MATCH (n:OBJECT)

where  n.object_type? = 'TABLE'

RETURN n

Note the question mark.

[Wes Freeman]

You should omit the start clause for this one.

[Michael Hunger]

Create index on :Object(object_type);

MATCH (n:OBJECT)

where  n.object_type = 'TABLE'

RETURN n

Will use an index lookup

Sent from mobile device

--
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+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.