Suiteql Coalesce not working

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that there are a few common issues when trying to use SQL-like queries in SuiteQL: 1. Window Functions: SuiteQL does not support all SQL window functions. The user in the first conversation was trying to use the

SUM() OVER (PARTITION BY ... ORDER BY ...)

window function, which may not be supported in SuiteQL. 2. Joins: In the second conversation, the user was having trouble with an OUTER JOIN. The suggestion was to specify LEFT/RIGHT OUTER JOIN instead. 3. Syntax Differences: In the third conversation, the user was having trouble with a CASE statement in a saved search. The issue was resolved by replacing double quotes with single quotes. Another suggestion was to use the

DECODE()

function instead of

CASE

. Remember, when translating SQL to SuiteQL, not all SQL functions and syntax are supported. It's important to refer to the SuiteQL documentation and test your queries thoroughly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******