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?
One of the variants of api.find()
has the “fields” parameter where you can define which columns you want to summarize. You can pass a map into this parameter in the format ['attribute' : 'aggregation type'], where aggregation type can be one of SUM, AVG, MIN or MAX. See the api.find() API documentation for more info.