Back
Searching by attribute "songName" requires fulltext index error, despite having a fulltext index
I'm trying to make a search function, but even though the attributes that I am using for Query.search() have a fulltext index, I get an error stating that the attribute requires a fulltext index.
This is my code that lists the documents from the database with the queries:
TypeScript
levels, err := database.ListDocuments(
"mixtaper",
"levels",
database.WithListDocumentsQueries(
[]string{
query.Search("songName", searchQuery),
query.Search("songArtist", searchQuery),
query.Search("description", searchQuery),
query.Search("chartName", searchQuery),
},
),
)
TL;DR
Issue: Error message states that the attribute "songName" requires a fulltext index despite having one when using `Query.search()` function.
Solution: Ensure that the attribute "songName" is specifically set as FULLTEXT in the database schema configuration.