How to do a redisearch search for items that have @field with a - in it?

Question

I have an redisearch index with products where the fields does contain special characters like "-". I'm keep hititng the wall with trying to do a search for products where the category field is "Multiroom-høttaler".

Here is a sample entry straight from redis-cli:

 1) shortDescription
 2) "\"Urbanears Stammen multiroom-h\xc3\xb8yttaler leverer stor, velbalansert lyd i et design som harmonerer med interi\xc3\xb8ret til ethvert hjem.\""
 3) brand
 4) "\"Urbanears\""
 5) title
 6) "\"Urbanears Stammen multiroom-h\xc3\xb8yttaler (bl\xc3\xa5)\""
 7) articleNumber
 8) "\"STAMMENBU\""
 9) category
10) "\"Multiroom-h\xc3\xb8yttaler\""

I have tried the following, including running ft.explain on all of them from cli and rdm with no luck in getting any hits. I also want it to be an exact match.

So far they all return 0 hits.

ft.search no @category:Multiroom-høyttaler
ft.search no @category:Multiroom\-høyttaler
ft.search no @category:Multiroom\\-høyttaler
ft.search no @category:\"Multiroom-høyttaler\"
ft.search no @category:\"Multiroom\\-høyttaler\"
ft.search no @category:\\"Multiroom\-høyttaler\\""
ft.search no @category:"\\"Multiroom\\-høyttaler\\""

I would expect to get all the products with the category Multiroom-høyttaler.

Your problem is that you also need to *index* the field with the `-` escaped. — Mark Nunberg, Aug 14 '19 at 08:15
Furthermore, I might suggest that a field such as "category" be a `TAG` field, as I imagine there are few options to choose from. — Mark Nunberg, Aug 14 '19 at 08:15
@MarkNunberg Thank you I will give this a test. Bit unsure about hwo to use TAG but will read up on it. — Fredrik, Aug 14 '19 at 08:29
@MarkNunberg the reindexing with escapes worked. Thank you, give at as an answer and I'll accept it. — Fredrik, Aug 14 '19 at 08:51

score 4 · Accepted Answer · answered Aug 15 '19 at 09:03

4

Your problem is that you also need to index the field with the - escaped.

answered Aug 15 '19 at 09:03

Mark Nunberg

3,551
15
18

can you elaborate as to how this is done? – Sami Fouad Mar 16 '21 at 10:17
@SamiFouad you need to replace all `-` to `\-` when inserting – Jonathan Apr 27 '22 at 18:17

How to do a redisearch search for items that have @field with a - in it?

1 Answers1