Query.search limitation

Since string is deprecated I used varchar, and now I cant use Query.contains , so I setup fulltext index and started using Query.search the issue is Query.search is very bad at searching, if I have string abc-123 then I have to write abc to get the row, otherwise no other way will match such as bc or 123 I guess it have an issue with special characters or numbers. or it's just bad at doing search.

TL;DR

Searching for a specific string containing special characters was causing mismatches, fixed by using quotes around the string in the search query. Further investigation needed for partial matches after a hyphen. Original query issue resolved by using varchar with contains function.

ummm i think varchar should work with contains, let me check

Hey, can you share the issue you get when trying to use contains on a varchar?

For the search issue, there is a 3 char min for matches; bc can never match. 123 should though. Are you sending it as a string? Query.search('', '123')?

this is from console

Thanks, checking on this

yes its string but the other issue with special characters say the string SWT-2621-44 when searching the same text it will return all ones that match the SWT not caring if match the reset of the text after the - character

This one I think is a quirk of the DB, because - is considered a stop character. Can you try with it in quotes? Like Query.search(attribute, '"SWT-2621-44"')