#community-help

Handling Special Characters in Facets and Queries

TLDR Greg experienced issues with faceting on field values with special characters. Kishore Nallan suggested using the symbols_to_index configuration during collection creation to index the special characters.

9mo

Join the chat

Mar 13, 2023 (9 months ago)

Photo of md5-1ea63728effc51f48c3ffecdc8646553

Greg

01:09 PM

Facets returned on field ending with + or - chars are not working. For some reason, when I facet on a field with values (M+, M, M-, NM+, NM, NM-) I get back only 2 facets with one of the M values randomly and one of the NM values randomly. The counts group all the M values together and all the NM values together. Is there a way to escape characters when faceting so it treats them distinctly? Same issue when doing a query - “NM-” returns all the NM values.

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

01:12 PM

Yes, please use the symbols_to_index configuration while creating the collection to enable indexing of those symbols.

{
        "name": "coll_name",
        "fields": [           
          {"name": "title", "type": "string"}
        ], "symbols_to_index": ["+"]
      }

Greg

01:13 PM

Thanks for the fast reply - Loving the product and support team!

01:22

Greg

01:22 PM

One follow-up: Update Schema in Cloud TS replies: Error: e: Request failed with HTTP code 400 | Server said: Only fields can be updated at the moment. Do I need to use API or other easier way to modify an existing schema?

Kishore Nallan

01:25 PM

You will have to recreate the collection, unfortunately.

01:26

Kishore Nallan

01:26 PM

Since this configuration affects all indexing of all fields, it is not easy to update it.

Greg

01:26 PM

Makes sense - I will do that. Update would be a nice future feature. Thank you once again.

Kishore Nallan

01:27 PM

Agreed

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3015 threads (79% resolved)

Join Our Community

Similar Threads

Querying with Special Characters in Collections

Hariharan asked about querying with special characters. Kishore Nallan explained to use `symbols_to_index` configuration while creating the collection.

9mo

Issue with Typesense Search and Special Characters

gab faced an issue with Typesense when searching with special characters. Jason and Kishore Nallan provided support and identified the issue as a bug. The problem was resolved after upgrading to `0.25.0.rc44`.

5mo

Faceting issue with Products Collections in Typesense

Carl was unable to facet on a string array. Kishore Nallan and Jason advised ensuring facet counts were being returned and offered to assist in troubleshooting. Issue resolved upon Carl realizing no data was saved in the database.

29mo

Issue with Special Characters in Facet Names

arif faced a problem with special characters, specifically colons, in facet names. Kishore Nallan advised using a-zA-Z0-9_ as the safest subset and confirmed no workaround for field names.

7mo

Issue with Embedding Error in Version 0.25.0.rc63

Bill reported a bug in version 0.25.0.rc63 regarding a problem with updating or emplacing a document and receiving an embedding error. This was resolved in version 0.25.0.rc65, but further discussion ensued regarding the function of 'index' in the update feature.

4mo