Thanks Michael, that seems solved my issue.
On Tue, Feb 12, 2019 at 4:49 AM 'Michael Hunger' via Neo4j <
neo4j@googlegroups.com> wrote:
> it's expensive and you need to do
>
> WHERE toLower(e1.word) IN [w in e2.WordsList | toLower(w)]
>
> or
>
> WHERE ANY(w IN e2.WordsList WHERE toLower(e1.word) toLower(w))
>
>
> you can also store lower case words in your properties, or add a 2nd
> property to check for that.
>
>
> I am having issues caused by case sensitive matches ,
> can someone please help ?
>
> here is my query:
>
>
>> MATCH (e1:Entity), (e2:Entity) WHERE e1.Word in e2.WordsList and e1.Word
>> ={name}
>>
>
> Word is a string
> WordsList is List<string>
>
> how can I ignore the case when checking if a word is inside a list ?
>
>
> Join our new Community Site & Forum <https://community.neo4j.com>
>
>
> On Tue, Feb 12, 2019 at 11:46 AM <devher...@gmail.com> wrote:
>
>>
>> Hi,
>>
>> I am having issues caused by case sensitive matches ,
>> can someone please help ?
>>
>> here is my query:
>>
>>
>>> MATCH (e1:Entity), (e2:Entity) WHERE e1.Word in e2.WordsList and e1.Word
>>> ={name}
>>>
>>
>> Word is a string
>> WordsList is List<string>
>>
>> how can I ignore the case when checking if a word is inside a list ?
>>
>>
>> Thanks
>>
>> --
>> 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.
>
--
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.
