You are not logged in.
Pages: 1
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
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
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
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
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
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
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
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
Is there anyone who can help? Or this asking is too complicated for you DEVs??
Offline
Ok, why is this forum existing if when someone have problem nobody is trying to help???
Offline
> 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
Pages: 1