Re: [eGroupWare-users] order items as numbers and not as text

[Ralf B. <rb...@st...>]

Hi Pavel,

Am 22.03.15 um 09:17 schrieb Pavel Novák:
> Thank you Ralf,
>
> float would be excellent, but there is no possibility to set custom
> field to any type of number :/
That's wrong, there was typo Float and now I added also type Integer
plus nummeric sorting for both, had a couple of minutes to spare on Sunday.

It's now in svn and will be in next 14.2 package.

Ralf
> To fix it in a source is not possible, I do not want all text fields
> sorted as float. Or you thought to add new type of custom field?
>
> Leading zeros is the solution, but it do not look nice, when
> displayed. Maybe I will try to save it with leading zeros, but too
> display it without.
>
> I have another problem. I displayed some of the custom fields by
> e-template. I choose Label, and ${row}[#custom] as name.
> If I switch columns "custom fields" by the "Select columns" dialog,
> everything is ok.
>
> But when I switch off columns "custom fields" by the "Select columns"
> dialog, there are no values even in my custom fields columns defined
> by eTemplate.
>
> I want to have displayed only some custom fields, and in the columns
> defined by me. But it does not work if I disable "custom fields" by
> the "Select columns" dialog :(
>
> Pavel
>
> Dne 21.3.2015 v 17:30 Ralf Becker napsal(a):
>> Hi Pavel,
>>
>> Am 21.03.15 um 14:30 schrieb Pavel Novák:
>>> Hi,
>>>
>>> I created custom field for Resouces application. The field should be a
>>> number, but there is no possibility to set the type of custom field as
>>> a number. I had to choose type "text".
>>> I enabled the created field's column in the resources main view.
>>> There is a possibility to order the items by click the header of the
>>> column.
>>>
>>> How is it possible to sort the items according the custom field as a
>>> number?
>> Only as float, not Integer AFAIK, thought there are currently sorted
>> alphabetical.
>>
>> As a workaround you could use a text-field and fill up the number with
>> leading zeros, that would sort correct.
>>
>> Or you need to fix it in the source ...
>>
>> Ralf
>>> There are items that have the following values in a custom field:
>>> "12", "35", "25", "124",...
>>> It is ordered as a text: "12", "124", "25", "35"
>>> But I need to ordered it as a numbers: "12", "25", "35", "124"
>>>
>>> Could you please help me? Thanks

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

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