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.
Add Comment
1 Answer(s)

Hi,

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.

Thanks,

Chris

Intermediate Answered on January 25, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor