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…
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
This works as expected:
select itemid from item group by itemid
This works as expected:
select storedetaileddescription from item
This gives the error, “Search error occurred: Invalid or unsupported search”:
select storedetaileddescription from item group by storedetaileddescription
Any idea why that would be?
