0

I am using Redisearch module in Redis and trying to filter the data stored in Redis index using the following query.

FT.AGGREGATE MyIndex * GROUPBY 1 "@MyField" FILTER "@MyField=='value'"

I am able to get the result only for the exact word searched, but not when searched with lower case letters for a field having upper case letters and vice versa. Eg: if a field is having 'test' as value, query with "@MyField=='TEST'" or "@MyField=='Test'" doesn't work.

Kindly suggest anything possible. Thank you.

chaitra d
  • 45
  • 5

1 Answers1

0

You can use the lower() function on both sides.

"lower(@MyField) == lower('TEST')"
Ariel
  • 529
  • 2
  • 13