Page 1 of 1

Devices organised by IP

Posted: Tue Jun 06, 2017 9:46 am
by ukzerosniper
Hi Guys,

When devices are organised by IP it doesnt seem to work. It gets the ordering all messed up.

https://1drv.ms/i/s!AgwFONjNYqXLjblO_c0vpIjw7lFvHQ

Re: Devices organised by IP

Posted: Wed Jun 07, 2017 1:48 pm
by Tomas
This is currently a known issue:
https://tracker.unimus.net/browse/UN-105

The problem basically is that we allow both IPs and hostnames for device addresses.
Sorting is done on the database layer, since we off-load all sorting and paging operations to the database itself.
(since every database does this best natively, and we support multiple)

We are working on fixing it, however it's proving to be difficult.
We wanted to write proper queries for each database, that will sort numbers naturally and hostnames as well, while at the same time not breaking paging.
Since we support multiple databases, this proved impossible, due to inherrent differences between database engines.

We will go with stored procedures to fix this, however it is being more difficult to properly implement than we originally anticipated.
(since this includes updating all database schemas, adding stored procedures as part of DB upgrade, testing on all DBs in all cases, etc.)

Long story short:
It will be fixed in one of upcoming releases :)

Re: Devices organised by IP

Posted: Wed Jun 14, 2017 3:09 pm
by ukzerosniper
lol, nice one. As long as your on it.