Possibility to sort groupedAggregates result

[tteguayco]

When using groupedAggregates, is not possible to sort the output? It would be very useful.

[benjie]

Does the orderBy not work for this?

[faridnsh]

I wanted to get the top 10 aggregated items, and such a query definitely didn't work:

query MyQuery {
  allLastTouchMatchesProducts(first: 10, orderBy: PRODUCT_QUANTITY_DESC) {
    groupedAggregates(groupBy: [PRODUCT_BRAND, PRODUCT_NAME]) {
      keys
      sum {
        productQuantity
      }
    }
  }
}

It resulted in the two following queries:

select /* NOTHING?! */
from "public"."last_touch_matches_products" as __last_touch_matches_products__
order by __last_touch_matches_products__."product_quantity" desc
limit ?

select
(coalesce(sum(__last_touch_matches_products__."product_quantity"), ?))::text as "0",
__last_touch_matches_products__."product_brand" as "1",
__last_touch_matches_products__."product_name" as "2"
from "public"."last_touch_matches_products" as __last_touch_matches_products__
group by __last_touch_matches_products__."product_brand", __last_touch_matches_produc

If the above is correct behavior and not a bug, then maybe the orderBy and first should be passed to groupedAggregates:

query MyQuery {
  allLastTouchMatchesProducts() {
    groupedAggregates(first: 10, orderBy: PRODUCT_QUANTITY_DESC, groupBy: [PRODUCT_BRAND, PRODUCT_NAME]) {
      keys
      sum {
        productQuantity
      }
    }
  }
}

[benjie]

That first query shouldn’t even exist!

I’m open to someone implementing this as a field argument to groupedAggregates