Type - IP Address

There is no type - IP address. This type needs its own sorting and restriction at the system level by values.

The problem is that when using a string, the sorting does not work correctly:
192.168.1.1
192.168.1.101
192.168.1.2

If you add leading zeros, this creates the need for a mandatory regular expression in each field, since not everyone remembers this need.

192.168.1.001
192.168.1.002
192.168.1.101

Then it makes it difficult to do a general search across the entire database, since it usually searches for an ip without a leading 0. For example, the Ip of a specific server.

One way could be to make the IP-address object more granular, with fields for all 4 positions and one for the full IP-address. That way you can sort on the individual positions and still search on the full address.

There is however a bug(?) in DataGerry that complicates this. It seems to ignore my sorting of the fields in the summary view and it treats the number 0 as N/A:

It’ll be time consuming to enter a large number of entries this way but that’s a perfect reason to break out your favorite scripting language. :slight_smile: