You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

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

Raff
Member
Registered: 2010-05-07
Posts: 54

Inventory number not sorted

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

Offline

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

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: Inventory number not sorted

Because this is an text field, not a number.


Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

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

Raff
Member
Registered: 2010-05-07
Posts: 54

Re: Inventory number not sorted

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

Offline

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

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: Inventory number not sorted

Use a fix length text, such as 001234

Order will be ok

000001
000012
000025
001234
004321
...


Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

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

ststefanov
Member
Registered: 2012-10-05
Posts: 2

Re: Inventory number not sorted

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?

Offline

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

marin.stefanoff
Member
Registered: 2012-11-28
Posts: 4

Re: Inventory number not sorted

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)

Offline

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

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: Inventory number not sorted

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


Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

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

marin.stefanoff
Member
Registered: 2012-11-28
Posts: 4

Re: Inventory number not sorted

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??

Offline

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

marin.stefanoff
Member
Registered: 2012-11-28
Posts: 4

Re: Inventory number not sorted

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

Offline

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

marin.stefanoff
Member
Registered: 2012-11-28
Posts: 4

Re: Inventory number not sorted

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

Offline

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

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: Inventory number not sorted

> 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.


Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

Board footer

Powered by FluxBB