# List sort is grouped by Database Type **URL:** \ **Category:** Bugs & Issues\ **Created:** [January 10, 2023, 12:47pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791 "2023-01-10T12:47:57Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 10, 2023, 12:47pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/1 "2023-01-10T12:47:57Z")
**Background** I have **Task** and **Action Item** types in a _List view_ and I’m trying to sort them by **State**. **Expected result** The rows are sorted by State. **Actual result** The rows are sorted by State but within each type. **Steps to reproduce** 1. Add two type with similar State field (e.g. Task and Action Item) 2. Change State to Done on an entity for each type 3. Add a List view and add the two types 4. Add a sort on the State field I may be missing something, please let me know! ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f39345abac629effa04dfaa5feec8b9c236725b5.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 10, 2023, 3:05pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/2 "2023-01-10T15:05:58Z")
I can’t reproduce. Are there any other sorts applied (on either of the databases)? ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 10, 2023, 3:29pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/3 "2023-01-10T15:29:55Z")
There are no other sorts applied. I just checked each Database (Task and Action Item) and they have the same options (Open, In Progress, Review and Done). I don’t know if it makes a difference but the two Databases are located in two different Spaces. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 10, 2023, 4:07pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/4 "2023-01-10T16:07:56Z")
Still can’t reproduce 😕 Are the State options completely identical for both dbs? Does a refresh make any difference? ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 10, 2023, 4:13pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/5 "2023-01-10T16:13:06Z")
I’ll see if I can share a workspace with this problem, hopefully I’m missing something. I should have stated it earlier, but it’s not a huge issue if it turns out it is a bug. ---
**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/max/32/6063_2.png) [@Max](https://community.fibery.io/u/Max)\ **Post date:** [January 10, 2023, 4:58pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/6 "2023-01-10T16:58:08Z")
Hey there, are you sure your states in the field are in the desired order? If your field looks like this: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/4e171c25f8987ee3eb1798c60408af8f627976a4.png) An ascending sort will sort it like: Open → Done In Progress ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 10, 2023, 5:12pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/7 "2023-01-10T17:12:19Z")
Yeah they are in the desired order. I created a new Space as a test and within it Databases: Task and Action Item. Everything works fine when creating a List view and the sort is correct, i.e. it sorts correctly across the two types. I then wanted to see if the problem comes from having databases in two different spaces. So I created a new Space with the Database: Action Item Other. I then created a List view with Task from one Space and Action Item Other from the newly created space. Works fine here as well. As soon as I involve either Task from Project Management or Action Item from Meetings in to the List view, they start being grouped per database type first, and state second. So there’s something going on with those two. Now they are much more complex than my test examples so I’m going to have to dig deeper. Either I have missed something obvious or there is something in Task and Action Item that groups by Database first and State second. But I realize it may be something very specific to my setup, I’m just trying to recreate it now 😃 ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 10, 2023, 5:13pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/8 "2023-01-10T17:13:42Z")
As you can see in the image, the sort is not consistent. Open comes after Done again. And you can sort of make out from the colors that they are grouped by Database type first. ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 10, 2023, 6:35pm UTC](https://community.fibery.io/t/list-sort-is-grouped-by-database-type/3791/9 "2023-01-10T18:35:24Z")
I’ve tried multiple things to recreate it now but can’t trigger it without including one of the two initial Databases (Task and Action Item). I’m going to leave it here without a solution (because the problem does exist for me) if I manage to recreate it somehow or if someone else stumbles upon a similar problem. But it’s probably not a high priority bug 🙂 I reported it because I really like Fibery and would want to see it at its best version 🙂