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…
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.