- Log in to post comments
User bio
404 bio not found
Member since Sep 8, 2021
Posts:
Replies:
Thank you, Robert! I think you are right about those NOISEWORDS. I tested against other words in that set and noticed the same behavior where %CONTAINS did not return results but the [ operator did. Appreciate the follow-up and detailed explanation!
- Log in to post comments
Thank you for the responses. To clarify, I did read the documentation for %CONTAINS as a starting point before posting this question on the developer community.
The datatype of the column (property) I am using %CONTAINS on is of %Text and the LANGUAGECLASS is set to a custom class that extends %Text.English.
Perhaps there is something in the docs that I'm missing that would cause the issue with the searching for the "time" word I'd mentioned above.
However, it seems like @Robert Cemper 's suggestion with using the [ operator achieves the same functionality I'm looking for with a similar performance time - when tested in the SQL page of the management portal.
- Log in to post comments
Certifications & Credly badges:
Vivian has no Certifications & Credly badges yet.
Followers:
Vivian has no followers yet.
Following:
Vivian has not followed anybody yet.
$ORDER works perfectly. Thank you all!