Hi,
Currently addressbook application uses some kind of sorting of entries, which leads
to entries being sorted like this: (in any field that is sortable by)
.
.
.
139 Some Avenue
14 Some Avenue
140 Some Avenue
.
.
.
149 Some Avenue
15 Some Avenue
150 Some Avenue
.
.
.
If a zero is prepended to address number, it goes normal again:
.
.
014 Some Avenue
015 Some Avenue
.
.
.
139 Some Avenue
140 Some Avenue
.
.
150 Some Avenue
But that’s not how ‘normal’ people write addresses…
Also in ‘custom fields’, this forces us to prepend zeros to
a field that is only supposed to contain a number, just to
have sorting correctly working.
Is this behavior somehow configurable? Or is it as provided by the database?
It’s the later, street is just a regular varchar column and sorted as that.
Ralf
Ralf Becker
Director Software Development
Stylite AG
Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30
Email: rb@stylite.de
www.stylite.de | www.egroupware.org
Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer
VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany
Live Security Virtual Conference
Exclusive live event will cover all the ways today’s security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
