Back
Fulltext Indexed JSON String not working on simple search query "the"
in the image is my JSON column that gets auto updated, I have a list of documents in a database. When I search the word "the", I get no results back. If I search "The", I also get no results back. Is there like some sort of anti "the" keyword filter here or what's going on where it wouldn't count it?
TL;DR
Issue: Searching for "the" or "The" on a JSON column is returning no results despite the presence of the term in documents.
Solution: Check if the full-text indexing configuration and case sensitivity settings are affecting the search query. Customize the search to handle case sensitivity or implement a different search strategy that includes stemming or stop words for better results. Query.search("search", props.searchQuery)
the Array(1) is because t returns one result lol
