# \[FIXED\] Ordering for Unsorted Entities **URL:** \ **Category:** Bugs & Issues\ **Created:** [April 16, 2024, 11:02pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086 "2024-04-16T23:02:46Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [April 16, 2024, 11:02pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/1 "2024-04-16T23:02:46Z")
Not a bug (I don’t think) but an annoying little issue I figured I’d bring up. We like to sort many things in the list view by dates (ascending), where the oldest thing is at the top of the list and the newest thing is at the bottom. For example: Entity 1 - Jan 1 Entity 2 - Feb 1 Entity 3 - Mar 1 Now, when a new entity is created and its date hasn’t been set yet, I want it to show up at the bottom of my list, but instead it always shows up at the top. So, expected: Entity 1 - Jan 1 Entity 2 - Feb 1 Entity 3 - Mar 1 Entity 4 - NO DATE but what I see: Entity 4 - NO DATE Entity 1 - Jan 1 Entity 2 - Feb 1 Entity 3 - Mar 1 It might be just me, but I would assume any undefined value should be LAST and not FIRST in a list that is sorted by ACCENDING. Basically, if something can’t be sorted, by default, display it at the bottom of the order instead of the top. Clickup, as a comparison, treats it the way I expect it to behave where anything that cannot be sorted is always at the bottom of the list. ![Week-70-4-29-5-5-Human-Code-List-](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d1ccb326c2c821d949ec6003e7de9040cf4060b2.jpeg) ---
**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:** [April 17, 2024, 6:09am UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/2 "2024-04-17T06:09:45Z")
See here > [@Choose order of empty values when sorting on Date field](https://community.fibery.io/t/choose-order-of-empty-values-when-sorting-on-date-field/1019): > > Hi, When we create a board view which is sorted on a Date field, if some cards have no date value filled in, then they are always displayed before cards which contain date values. This is problematic because when we want to display a classic “to do” list with cards sorted on “ascending” dates (to see on top what to do next), then all the cards without dates are coming first. It would be great if we could choose if cards containing an empty field are displayed before of after. Maybe with 4 ch… ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [April 17, 2024, 1:27pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/3 "2024-04-17T13:27:22Z")
Thanks for pointing me in this direction, added a vote. ---
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [April 17, 2024, 7:19pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/4 "2024-04-17T19:19:38Z")
Yep, it’s a real pain in the ass. FWIW; we’ve created several formulas to fix the sorting problems. For example; a checkbox that checks if a date is filled yes/no. ---
**Author:** ![Yuri\_BC](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yuri_bc/32/8803_2.png) [@Yuri\_BC](https://community.fibery.io/u/Yuri_BC)\ **Post date:** [April 17, 2024, 8:05pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/5 "2024-04-17T20:05:47Z")
+1 for this properly fixed. We need to show empty fields at the bottom…I have never encountered the need to have them at the top of the list. ---
**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:** [April 17, 2024, 8:47pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/6 "2024-04-17T20:47:29Z")
The order preference (empty first or empty last) is just that, a preference. There are cases where one or the other makes more sense, so there is nothing universally right (or proper) about either choice. Having said that, perhaps the default in Fibery is less popular, who knows? Anyway, letting the user choose (for entire workspace? per view?) might be nice, hence the linked to feature request. But I don’t think it will be worked on any time soon though, sorry. ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [April 18, 2024, 5:48am UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/7 "2024-04-18T05:48:42Z")
Went through some other apps to see where empty dates go when its sorted: Google Sheets: Always last Notion: Always last Coda: Always Last Monday: Treated as a date from 2050, First in descending, last in ascending Airtable: Treated as date from 1900, First in ascending, last in descending Same behaviour is seen with other null fields. I did some digging and it looks like the default for this depends on the database being used. [How ORDER BY and NULL Work Together in SQL | LearnSQL.com](https://learnsql.com/blog/how-to-order-rows-with-nulls/#:~:text=If%20you%20sort%20a%20column,the%20NULLs%20will%20come%20first.&text=Alternatively%2C%20if%20you%20add%20a,order%2C%20NULLs%20will%20appear%20last). I personally don’t mind them going to the top, as I see it kind of like reminding the user to fill it in. But it would definitely add that extra customisation “Fibery Touch” if we had a little dropdown in the sort options for “Empty Values”: “First | Last”. ---
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [April 18, 2024, 8:19am UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/8 "2024-04-18T08:19:54Z")
> [@RonMakesSystems](#): > > It would definitely add that extra customisation “Fibery Touch” if we had a little dropdown in the sort options for “Empty Values”: “First | Last”. That would be awesome, not only from a user perspective but also performance wise. Since we currently have multiple formulas in multiple databases for date is not empty, priority is not empty etc. Those can be removed if that feature is added. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [April 23, 2026, 2:48pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/9 "2026-04-23T14:48:32Z")
Now you can set where to show empty values in search results (top or bottom) [April 23, 2026 / Experimental UI pages creation via AI, Sort improvement](https://community.fibery.io/t/april-23-2026-experimental-ui-pages-creation-via-ai-sort-improvement/10763) ---
**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:** [April 23, 2026, 2:55pm UTC](https://community.fibery.io/t/fixed-ordering-for-unsorted-entities/6086/10 "2026-04-23T14:55:59Z")