Inventory number not sorted

Raff · 2011-07-02 23:09:00

I use the Inventory number with our asset managament, but when I want to sort all entries by "Inventory numbers" the sorting is not working like it should. Can any of you check where is the problem? Sorting by name is working.
For example if there is asset 999, 888, 1010, 1200 , sorting by asset number will give such result

999
888
1200
1010

Raff

remi · 2011-07-03 07:07:14

Because this is an text field, not a number.

Raff · 2011-07-03 10:13:36

Even if it is text than it is mixed. The question is how to make it possible to sort if I have only numbers.
But anyway if it is the text than it seems to be also not sorted the rigt way.

It is very important issue for us. When we add next asset, we want to know which was the last one, but if we can not sort it make things complicated. Sometimes we add asset not in order. For example we are adding asset nr 5000 after we added asset 5200, thus we have to have possibility to see what the last asset is.

Raff

remi · 2011-07-03 10:40:43

Use a fix length text, such as 001234

Order will be ok

000001
000012
000025
001234
004321
...

ststefanov · 2012-11-14 15:26:33

GLPI 0.83.4, when I put number like 0014 it is saved as 14 and sorting is broken.
14 appears after 100, for example.
Is it possible to use number sorting (or more intelligent) here?

marin.stefanoff · 2012-11-28 12:24:27

Hello,
We have the same problem with the numbers order. Examp:
01
16
25
03
108
11
And we need them to be:
01
03
11
16
25
108

Like Raff said, we need to check which was the last asset number.
Please help with a real answer because the given one is kind of ridiculous (at least i can't find the logic why a field called "Inventory number" is a text field, not number field???).

Last edited by marin.stefanoff (2012-11-28 12:25:32)

remi · 2012-11-28 13:29:16

Simply because an Asset number can be a lot of thing.... FR-2012-0001, 12-34-56-789, ...

marin.stefanoff · 2012-11-28 13:41:21

Ok, now i see the logic but what if it's just a number (as we want to use it)? How can we change this order counting??

marin.stefanoff · 2012-12-04 12:54:57

Is there anyone who can help? Or this asking is too complicated for you DEVs??

marin.stefanoff · 2012-12-12 18:24:10

Ok, why is this forum existing if when someone have problem nobody is trying to help???

remi · 2012-12-12 18:46:51

> Ok, why is this forum existing if when someone have problem nobody is trying to help???
Remember, people trying to help here, do it "freely" on their "free" time.

And you have an explanation in comment #7, and a workaround in comment #4.

> How can we change this order counting??
You cannot.

Forum GLPI-Project

Announcement

#1 2011-07-02 23:09:00

Inventory number not sorted

#2 2011-07-03 07:07:14

Re: Inventory number not sorted

#3 2011-07-03 10:13:36

Re: Inventory number not sorted

#4 2011-07-03 10:40:43

Re: Inventory number not sorted

#5 2012-11-14 15:26:33

Re: Inventory number not sorted

#6 2012-11-28 12:24:27

Re: Inventory number not sorted

#7 2012-11-28 13:29:16

Re: Inventory number not sorted

#8 2012-11-28 13:41:21

Re: Inventory number not sorted

#9 2012-12-04 12:54:57

Re: Inventory number not sorted

#10 2012-12-12 18:24:10

Re: Inventory number not sorted

#11 2012-12-12 18:46:51

Re: Inventory number not sorted

Board footer