Support sum() as a GROQ function

[kmelve]

trafficstars

It would be handy to have the ability to sum numbers in GROQ. The syntax would be similar to count(). It should probably validate that it's a field of the type Number (or just be like JavaScript and sum whatever).

*[_type == 'stats']{
    "pagestats": sum(pageStats[].pageLoads)
}

[coreyward]

Any word on this? Would be super useful for something I'm working on.

[kmelve]

I don't think it should be too hard to do, but I'll leave it to @judofyr to triage it.

[paul-vd]

I would also love to see this. Here is an example usecase

Example dataset

{
    "_type":"invoice",
    "request":{
        "_ref":"...",
        "_type:":"reference"
    },
    "items":[
        {
            "itemId":1,
            "price":1000
        },
        {
            "itemId":2,
            "price":2000
        },
        {
            "itemId":3,
            "price":3000
        }
    ]
}

An example query where this would be super usefull

*[_type=="request" && _id == $id]{
    invoices: *[_type=="invoice" && reference(^._id)]{
        "totalPrice": sum(items[].price), // shows the total price of all the items eg; 6000
        items
    }
}[0]

[KenEucker]

Echoing this, it would be nice to be able to add the up the size fields from the media in order to determine the size of a given group of media:

*[ _type in ["sanity.imageAsset", "sanity.fileAsset"] ]{"totalSize": sum(items[].size)}

[yob-yob]

any alternatives for the mean time? or do I really need to handle this JS side for now?

[judofyr]

any alternatives for the mean time? or do I really need to handle this JS side for now?

We definitely want to add this in the future, but at the moment we don't have a timeline for when it will be available. For now you need to handle this in JS.

[atombender]

Hi everyone!

We have now launched this functionality as math::sum(), along with a bunch more stuff.

We have also launched a new GROQ spec, which you can read about in our blog: Content is Queryable: (Re)Introducing GROQ.