SuiteQL GROUP BY
I have several times had working suiteQL queries that stopped working when I add a GROUP BY at the bottom. Has anyone else had this experience?
I get `Search error occurred: Invalid or unsupported search` when I add GROUP BY…
Rookie Asked on January 24, 2023 in SuiteScript.
You need to make sure that all columns are wither SUM(), MAX(), etc or included in the GROUP BY.
Happy to take a look at the query if that doesn’t resolve it for you.