Search for subdomains in string field
Hi
I have encountered an issue with the full-text search functionality. When searching for emails by subdomain, the system seems to remove special characters (like @ and .) and splits the subdomain into multiple words. This behaviour results in incorrect matches and makes it impossible to accurately find all emails with a specific subdomain.
For example:
Searching for @email.norwegianreward.com incorrectly splits it into email, norwegianreward and com
This is problematic for use cases where exact subdomain matches are required. Accurate full-text search for subdomains is a very basic and essential feature for applications handling email data.
Could you advise on how to resolve this issue or if there are any planned updates to improve the full-text search capabilities?
search:
{
from: "@email.norwegianreward.com"
}
results:
[
{ From: "newsletter@email.norwegianreward.com" },
{ From: "noreply@email.openai.com" }, //not interested
{ From: "info@email.home.saxo" },//not interested
{ From: "info@email.home.saxo" },//not interested
]
I have encountered an issue with the full-text search functionality. When searching for emails by subdomain, the system seems to remove special characters (like @ and .) and splits the subdomain into multiple words. This behaviour results in incorrect matches and makes it impossible to accurately find all emails with a specific subdomain.
For example:
Searching for @email.norwegianreward.com incorrectly splits it into email, norwegianreward and com
This is problematic for use cases where exact subdomain matches are required. Accurate full-text search for subdomains is a very basic and essential feature for applications handling email data.
Could you advise on how to resolve this issue or if there are any planned updates to improve the full-text search capabilities?
search:
{
from: "@email.norwegianreward.com"
}
results:
[
{ From: "newsletter@email.norwegianreward.com" },
{ From: "noreply@email.openai.com" }, //not interested
{ From: "info@email.home.saxo" },//not interested
{ From: "info@email.home.saxo" },//not interested
]
