# Elastic Search \> @SearchUI \> group with sort
**URL:** https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154
**Category:** Elastic Search
**Tags:** elastic-app-search
**Created:** [March 7, 2023, 8:12am UTC](https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154 "2023-03-07T08:12:05Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@parliament718](https://discuss.elastic.co/u/parliament718)
#### Post date: [March 7, 2023, 8:12am UTC](https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154/1 "2023-03-07T08:12:05Z")
I've been trying for days to get group+sort working with @search-ui, with either the app-search connector or the elasticsearch connector with limited success with both.
Originally I used the app-search connector and set the `group` on the query:
```auto
group: {
collapse: true,
field: 'card_code_rarity',
},
```
This almost gives me the result I want, with each search result containing a `_group` property with the documents in the group. The only additional thing I need is to sort by the count of these documents. If the following worked it would be fantastic:
```auto
group: {
collapse: true,
field: 'card_code_rarity',
},
sort: [
{ '_group.length': 'desc' },
],
```
But it doesnt. After hitting non-step dead-ends I decided to try to Elasticsearch connector with search-ui.
I can get some form of a usable end result with the following in POSTMAN:
```auto
aggs: {
card_code_rarity: {
terms: {
field: "card_code_rarity",
order: {
"_count": "desc"
}
},
aggs: {
my_docs: {
top_hits: {
sort: [
{
"selling_price": { "order": "desc" }
}
]
}
}
}
}
},
```
However this part of the query gets completely omitted by the Elasticsearch connector, it seems to not have support for this.... and it wont even forward the params as-is.
This connector also doesn't seem to have a `beforeSearch` hook like the app-search one, and it's not easy to extend it since it doesnt export `handleSearchRequest()`. So what to do?
Ideally, I can go back to using AppSearch connector and get the sorting to work somehow.
Otherwise how can I get the aggregate query to work with the Elasticsearch connector?
Actually, would be nice to know how to do it with either connector in case I need to switch again for some other limitation.
---
### Author:  [@parliament718](https://discuss.elastic.co/u/parliament718)
#### Post date: [March 7, 2023, 11:32am UTC](https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154/2 "2023-03-07T11:32:59Z")
Looks like I can achieve the _query_ I need using the second param handler to the connector like so:
```auto
const connector = new ElasticsearchAPIConnector(
{ ... },
(requestBody, requestState, queryConfig) => {
requestBody.aggs = queryConfig.aggs;
return requestBody;
}
);
```
This probably shouldnt be neccesary but I do get the expected results in the Chrome network tab.
However, yet another blocker here is I'm unable to extract the **full** Elasticsearch response from the connector, and there is nothing I can use in the `SearchDriver`'s `state` object.
---
### Author:  [@joemcelroy](https://discuss.elastic.co/u/joemcelroy)
#### Post date: [March 7, 2023, 12:04pm UTC](https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154/3 "2023-03-07T12:04:39Z")
hey @parliament718
You should be able to get the raw elasticsearch response for each result via the `_meta.rawHit`
>
Joe
---
### Author:  [@parliament718](https://discuss.elastic.co/u/parliament718)
#### Post date: [March 7, 2023, 12:17pm UTC](https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154/4 "2023-03-07T12:17:23Z")
@joemcelroy
Thanks for the reply.
Unfortunately that is not enough. I need the `aggregations` value at the root of the response. That is a siblings of `hits`.
---
### Author:  [@parliament718](https://discuss.elastic.co/u/parliament718)
#### Post date: [March 7, 2023, 12:19pm UTC](https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154/5 "2023-03-07T12:19:39Z")
I've been digging into the lib source like crazy and it's just so hard to extend because of all the default exports, none of the useful classes are exported.
As such, I can't extend `SearchkitResponseTransformer` which seems to be what I need. No way I see to provide my own
---
### Author:  [@parliament718](https://discuss.elastic.co/u/parliament718)
#### Post date: [March 7, 2023, 1:53pm UTC](https://discuss.elastic.co/t/elastic-search-searchui-group-with-sort/327154/6 "2023-03-07T13:53:07Z")
Even with some hacks to compiled code to get that property from the response, my implementation is broken in respect to pagination as it will just return the same buckets each time.
Is there a way to revert back to AppSearchConnector where it was returning the "\_group" on each hit and the pagination was working... that was sooooo close to what I need. All I need is to sort the hits by the count of docs in the \_group, like:
```auto
group: {
collapse: true,
field: 'card_code_rarity',
},
sort: [
{ '_group.length': 'desc' },