ANS-0091 · SAVED SEARCHES & FORMULAS
How to Resolve NetSuite Saved Search Issues with Dot in Text Field Criteria
When standard text field criteria in NetSuite Saved Searches fail to return expected results due to special characters like a dot, a Formula(Text) criterion provides a reliable workaround.
Short answer
A NetSuite Saved Search may return no results if a long text field criterion includes a dot (e.g., in a URL). Standard text criteria can be affected by database query sanitation rules. To resolve this, use a `Formula(Text)` criterion instead. This method successfully handles special characters, ensuring accurate search results.
Scenario
A NetSuite Saved Search is configured to search a long text field. When the search criterion includes a special character, specifically a dot (.), such as in a URL like "google.com", the search returns no results. However, searching for the same text without the dot (e.g., "google") yields correct results. This suggests a potential database query sanitation issue affecting standard text field criteria.
Solution
Attempts to resolve the issue by adding single quotes to the search criteria are unsuccessful. The effective solution involves utilizing a Formula(Text) criterion within the NetSuite Saved Search. This approach successfully bypasses the issue, allowing the search to correctly process criteria containing dots or other special characters without encountering data sanitation problems.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support