# Any possibility to order results in search filters
**URL:** https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761
**Category:** Ideas
**Created:** [September 24, 2019, 5:40am UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761 "2019-09-24T05:40:35Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@risto3](https://discuss.tryton.org/u/risto3)
#### Post date: [September 24, 2019, 5:40am UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/1 "2019-09-24T05:40:35Z")
When searching in accounts with parties, it would be nice to get more than one order field.
For example, how to search for records with an order by party and date
In OpenERP it was easy because of the grouping button…
cheers
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [September 24, 2019, 7:16am UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/2 "2019-09-24T07:16:40Z")
Indeed this is technicaly possible on the server side but the clients only implement the ordering by clickin on the row header which only allows to sort by one column.
From my point of view the current behaviour is good for most users but probably on some reporting screens it will be better to have some kindof button to allow to select multiple sorting options.
> [@risto3](#):
>
> In OpenERP it was easy because of the grouping button…
BTW, did you have some screenshoot about the UI interface implementing the option to sort by multiple columns?
---
### Author:  [@risto3](https://discuss.tryton.org/u/risto3)
#### Post date: [September 24, 2019, 8:11am UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/3 "2019-09-24T08:11:57Z")
> [@pokoli](#):
>
> BTW, did you have some screenshoot about the UI interface implementing the option to sort by multiple columns?
(unfortunately, for the privacy laws I needed to occlude some things… hopefully the gist of things is evident)
In OpenERP, the order of selecting the regroup buttons is significant too,
it was a powerful feature that _everyone_ **really** liked.
That is, ‘by partner’ and ‘by period’ is a different display than ‘by period’ and ‘by partner’
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [September 24, 2019, 8:31am UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/4 "2019-09-24T08:31:51Z")
> [@risto3](#):
>
> In OpenERP, the order of selecting the regroup buttons is significant too,
> it was a powerful feature that _everyone_ **really** liked.
> That is, ‘by partner’ and ‘by period’ is a different display than ‘by period’ and ‘by partner’
But this feature is about grouping and we are talking about sorting.
Grouping on all models is not supported on Tryton
---
### Author:  [@risto3](https://discuss.tryton.org/u/risto3)
#### Post date: [September 24, 2019, 8:35am UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/5 "2019-09-24T08:35:05Z")
I guess while I’m here, I’ll mention that it is somewhat difficult today to display GL entries in multiple subaccounts. In OpenERP this was easy, as one would only select the root account..
For example, above is just the ‘411116’ account, somewhat like one would get with Account Plan → Account and selecting that account.
I can’t seem to find a way to stipulate ‘41111’ (or ‘41111%’) in order to get all the subaccounts listed under ‘41111x’.
This turns out to be a bit of a pain as, for example in the French plan, it is designed around easily making subaccounts… so browsing/searching for moves can be difficult without this possibility in Tryton.
cheers,
---
### Author:  [@risto3](https://discuss.tryton.org/u/risto3)
#### Post date: [September 24, 2019, 9:10am UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/6 "2019-09-24T09:10:46Z")
> [@pokoli](#):
>
> But this feature is about grouping and we are talking about sorting.
> Grouping on all models is not supported on Tryton
Technically speaking (in SQL terms) what you say is correct.
In a simplistic user experience, if it was possible to specify the ORDER clause with the current data, then it would be far more powerful than not having it.
That is, it is somewhat disturbing to be able to sort by date, or by party, but not by party and date.
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [September 24, 2019, 1:31pm UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/7 "2019-09-24T13:31:27Z")
> [@pokoli](#):
>
> From my point of view the current behaviour is good for most users but probably on some reporting screens it will be better to have some kindof button to allow to select multiple sorting options.
On a [quick research](https://ux.stackexchange.com/questions/34786/sorting-tables-after-multiple-columns), there seems to have three options:
- Add an index next to the sorting arrow which show the place in the sorting
- Use the column order in the view (and maybe allow to reorder them)
- Add an “editor” on the side (like the search box)
For me, the index solution seems the best choice.
---
### Author:  [@risto3](https://discuss.tryton.org/u/risto3)
#### Post date: [September 24, 2019, 1:56pm UTC](https://discuss.tryton.org/t/any-possibility-to-order-results-in-search-filters/1761/8 "2019-09-24T13:56:53Z")
Seems like a good idea.
Couldn’t the index be added in the search box to specify/show the columns in each index?