RJMNS
09/23/2025, 3:27 PMCeligo AI
09/23/2025, 3:27 PMAI generated answer (using internal Slack threads):The reason for providing saved search formulas as replies containing double quotes is due to the formatting requirements of the platform where the conversation is taking place, in this case, Slack. Slack uses a markdown-like language for formatting text, and in this language, double quotes are used to denote a block of code or a command. However, when writing a formula in NetSuite's Saved Search UI, it's a good practice to use single quotes for string literals and double quotes for any Identifier. This is because you are writing an Oracle SQL (or using the Oracle SQL functions and expressions), so it makes sense to follow the Oracle standard. In the context of the Slack conversation, the double quotes are used to clearly indicate the start and end of the code snippet or command. But when you are implementing the formula in NetSuite, you should replace the double quotes with single quotes. For example, in the Slack conversation, a formula might be presented as:
CASE WHEN {status} = "Rejected by Supervisor" THEN "Yes" ELSE "No" END
But when you implement this in NetSuite, you should use:
CASE WHEN {status} = 'Rejected by Supervisor' THEN 'Yes' ELSE 'No' END
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
09/23/2025, 3:27 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.860290706
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.84942627
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840393245
Celigo AI
09/23/2025, 3:27 PM