I am trying to sort a query that matchs first and last name buy first
name and last name. first name can be capitalize or could be all lower
case. I wanted to covert first name + last name to lower case before
it sort.
Example: Currently I query looks like this:
"start n=node(%d) match n-[:MEMBERSHIP]->m<-[:MEMBERSHIP]->u where
(u.firstName =~/(?i)%s.*/ or u.lastName =~/(?i)%s.*/) %s return u
order by u.firstName, u.lastName limit %d"
I want to able to do something like this:
"start n=node(%d) match n-[:MEMBERSHIP]->m<-[:MEMBERSHIP]->u where
(u.firstName =~/(?i)%s.*/ or u.lastName =~/(?i)%s.*/) %s return u
order by u.firstName.lowercase, u.lastName.lowercase limit %d"