Question
When searching the Product Extensions (or product master), it would be sometimes useful to be able to calculate SUM or AVG of certain columns. I.e., we need to make a Group By for api.find(). Is that possible?
Answer
One of the variants of api.find() has a parameter where you can define which columns you want to summarize.
See the API documentation.