# Order by descending only ordering by first digit instead of entire number

**URL:** <https://forum.inductiveautomation.com/t/order-by-descending-only-ordering-by-first-digit-instead-of-entire-number/71459>\
**Category:** Ignition\
**Tags:** vision, ignition81\
**Created:** [March 22, 2023, 7:07pm UTC](https://forum.inductiveautomation.com/t/order-by-descending-only-ordering-by-first-digit-instead-of-entire-number/71459 "2023-03-22T19:07:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brennan\_Joles](https://avatars.discourse-cdn.com/v4/letter/b/d2c977/32.png) [@Brennan\_Joles](https://forum.inductiveautomation.com/u/Brennan_Joles)\
**Post date:** [March 22, 2023, 7:07pm UTC](https://forum.inductiveautomation.com/t/order-by-descending-only-ordering-by-first-digit-instead-of-entire-number/71459/1 "2023-03-22T19:07:00Z")

</div>

Every other column but "TimeBehind" sorts by the entire number and they are all created the same. Here is a screenshot of the column "TimeBehind" sorting by only the first digit instead of the entire number:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/8/a8500e0ce36e409b7c78caeedf46d3ca7ffa1273.png)

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [March 22, 2023, 7:36pm UTC](https://forum.inductiveautomation.com/t/order-by-descending-only-ordering-by-first-digit-instead-of-entire-number/71459/2 "2023-03-22T19:36:51Z")

</div>

Interesting. Can you open up the dataset editor and see what the datatype of that column is vs the columns that are working properly?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/8/38ed4501036c4ee8cb62c96cfa7e2451149574ae.png)

---

<div class="post-metadata">

**Author:** ![Brennan\_Joles](https://avatars.discourse-cdn.com/v4/letter/b/d2c977/32.png) [@Brennan\_Joles](https://forum.inductiveautomation.com/u/Brennan_Joles)\
**Post date:** [March 22, 2023, 7:49pm UTC](https://forum.inductiveautomation.com/t/order-by-descending-only-ordering-by-first-digit-instead-of-entire-number/71459/3 "2023-03-22T19:49:25Z")

</div>

It was an integer, but I got it fixed. I just deleted the column and the group in the transaction group and remade it the exact same way and it worked. Seemed like just a bug or maybe editing the block group after making it caused an issue. Thanks!