the attachment shows my code. I'm trying to search a string array type column, but want to exclude docs that have a specific text, using the notEqual method. I've created a fullText type index with both of the columns included (the second attachment shows my index). but it still throws an error in the console saying Server Error. when I checked the container logs, I found Can't find FULLTEXT index matching the column list. don't know what's happening
Summary
User is experiencing an error message stating "Can't find FULLTEXT index matching the column list" despite having a full text index. They have two indexes: one full text index with 'betDigitArray' and one key index with 'betType'. They are requesting assistance to create a full text index only with 'betDigitArray'. User has provided code and attachments showing their index creation. They are trying to search a string array column and exclude documents with a specific text using the notEqual method. The error occurs and user is unsure of what is happening.
Solution: It seems that the issue is caused by not having a full text index
Drake
Admin
Mar 25, 2023, 02:28
Did you create a full text index on betDigitArray?
manazo
Rank 3: Container
Mar 25, 2023, 05:57
as the 2nd attachment shows, i created a fullText index with both betDigitArray and betType
Drake
Admin
Mar 25, 2023, 15:58
would you please create 1 full text index with only betDigitArray?
manazo
Rank 3: Container
Mar 25, 2023, 17:33
1 fullText index with betDigitArray & 1 key index with betType?
Drake
Admin
Mar 25, 2023, 17:42
The one you currently have and 1 full text with only the search attribute