Cypher queries using Lower/Upper/Ignore case on property

[gustavoboby]

Hi guys,

I'm need make a query using a lower/upper/ignore case, can be possible
using cypher?

Sample:

POST /db/data/ext/CypherPlugin/graphdb/execute_query { "query": "start
x = node:index_padrao(Tipo='Perfil') WHERE TOLOWER(x.Nome)
=~ /.*gustavo o.*/ return x.Nome SKIP 0 LIMIT 10 " }

Thank's

[Peter Neubauer]

Mmh,
Since you can do regexp, you should be able to match on ignorecase
there? Have you tried something like
http://www.regular-expressions.info/modifiers.html ?

Cheers,

/peter neubauer

TC CEO of the year - vote for Emil Eifrém!
http://crunchies2011.techcrunch.com/nominate/

Google:neubauer.peter
Skype:peter.neubauer
Phone: +46 704 106975
LinkedIn   http://www.linkedin.com/in/neubauer
Twitter      @peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

[Andres Taylor]

On Fri, Dec 16, 2011 at 3:51 PM, Peter Neubauer <peter.n...@neotechnology.com> wrote:

Mmh,
Since you can do regexp, you should be able to match on ignorecase
there? Have you tried something like
http://www.regular-expressions.info/modifiers.html ?

Doesn't work. We should definitely support it. 

Andrés

[Peter Neubauer]

Issue-worthy?

Cheers,

/peter neubauer

TC CEO of the year - vote for Emil Eifrém!
http://crunchies2011.techcrunch.com/nominate/

Google:neubauer.peter
Skype:peter.neubauer
Phone: +46 704 106975
LinkedIn   http://www.linkedin.com/in/neubauer
Twitter      @peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

[Andres Taylor]

On Fri, Dec 16, 2011 at 4:02 PM, Peter Neubauer <peter.n...@neotechnology.com> wrote:

Issue-worthy?

Yes.

https://github.com/neo4j/community/issues/139

Andrés 

[Andres Taylor]

On Fri, Dec 16, 2011 at 3:32 PM, gustavoboby <gusta...@gmail.com> wrote:

I didn't know enough about the Java Pattern, which is what I use to match on the regular expressions. You can do it like this:

startx  = node:index_padrao(Tipo='Perfil')

WHERE x.Nome =~ /.*(?i)gustavo o.*/ 

return x.Nome SKIP 0 LIMIT 10

The (?i) at the start of the regular expression turns it into a case insensitive match.

And, yes Peter, I have added it to the manual. :)

Andrés

[Peter Neubauer]

That's my boy :)

Cheers,

/peter neubauer

TC CEO of the year - vote for Emil Eifrém!
http://crunchies2011.techcrunch.com/nominate/

Google:neubauer.peter
Skype:peter.neubauer
Phone: +46 704 106975
LinkedIn   http://www.linkedin.com/in/neubauer
Twitter      @peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

[luiz gustavo bosco de oliveira]

Hi guys,

I'm not in the company where I work now, so I have no access to my source code. But once you get there tomorrow, I do the test!

Now, thanks!

Att
Gustavo

2011/12/17 Peter Neubauer <peter.n...@neotechnology.com>

--
Att.
Luiz Gustavo Bosco de Oliveira
Analista Desenvolvedor.