#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.

6mo

Join the chat

Mar 13, 2023 (6 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 2764 threads (79% resolved)

Join Our Community Manage subscription

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.

6mo

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`.

2mo

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.

24mo

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.

4mo

Resolving Multilingual Search Function in Typesense Software

Bill is having difficulty with multilingual search functionality in Typesense software. Developer Kishore Nallan suggested setting a language locale and provided a demo build. The build solution had some issues, and after multiple rounds of software updates and troubleshooting, the problem still persists.

21mo