Hi Sergey,
I do not know if it is a bug of the new "Diff Hours" field type in version v2.3 or if it's a new MySQL config problem, but I post it here looking for help and because this trouble can happen to other users...
When registering a new field of the type "Difference of hours" gives me the error that can be seen in the image below to list the field data:
regards
elviseras
"Diff Hours" Type Field Error
- elviseras
- Investor
- Posts: 578
- Joined: 08 Feb 2017, 03:16
- Name: Elvix Sampedro
- Location: Galicia - Spain
- Company Name: novaTEK
Re: "Diff Hours" Type Field Error
Hi again and Sorry!!, It seems that I have already solved the problem!!!... In MySQL config file I have configured the following value:
32bits Server: thread_stack = 128K
64bits Server: thread_stack = 256K
Now the new type of "Diff" type field seems works perfectly, but should have, but it should have the same formatting options as the other numeric fields (Number format, Prefix, etc)....See image below regards
elviseras
Note that the following is recommended:thread_stack = 256K
32bits Server: thread_stack = 128K
64bits Server: thread_stack = 256K
Now the new type of "Diff" type field seems works perfectly, but should have, but it should have the same formatting options as the other numeric fields (Number format, Prefix, etc)....See image below regards
elviseras
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: "Diff Hours" Type Field Error
Can you explain me why we need Prefix/Suffix for this field type?
- elviseras
- Investor
- Posts: 578
- Joined: 08 Feb 2017, 03:16
- Name: Elvix Sampedro
- Location: Galicia - Spain
- Company Name: novaTEK
Re: "Diff Hours" Type Field Error
Yes!! Because we use several time fields for extract statistics on users performance in tasks and tickets, and comparing SLA times with other time values. In some instances we use days and in others we use hours or other values.
As you can see in the image, it is not consistent that the columns have different format ..
regards
As you can see in the image, it is not consistent that the columns have different format ..
regards
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: "Diff Hours" Type Field Error
Ok, prefix and suffix is easy to add and I have added it. Unpack archive to includes\classes\fieldstypes\
Let me know if it works ok.
This change will be included in 2.3
Let me know if it works ok.
This change will be included in 2.3
- Attachments
-
- fieldstypes.zip
- (4.49 KiB) Downloaded 252 times
- elviseras
- Investor
- Posts: 578
- Joined: 08 Feb 2017, 03:16
- Name: Elvix Sampedro
- Location: Galicia - Spain
- Company Name: novaTEK
Re: "Diff Hours" Type Field Error
Ok, Prefix/Sufix Config already works, but even more important to us is to be able to configure the "Number Format" option, because as I commented there are inconsistencies in list numbers view (Especially in average values calculation). See right column in new image below...
regards- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: "Diff Hours" Type Field Error
I see, replace attached file to includes\classes\fieldstypes\
Now you can configure number format.
Is it ok now?
Now you can configure number format.
Is it ok now?
- Attachments
-
- fieldtype_hours_difference.php
- (8.12 KiB) Downloaded 294 times
- elviseras
- Investor
- Posts: 578
- Joined: 08 Feb 2017, 03:16
- Name: Elvix Sampedro
- Location: Galicia - Spain
- Company Name: novaTEK
Re: "Diff Hours" Type Field Error
Now, it´s better, but still there are some differences:
1.- In rows, data should be aligned to the right (However in total / average lower cell it's fine)
2.- In rows, decimals aren't show if the number is integer (However in total / average lower cell it's fine)
You can see the difference in the image. First column (left) is a formula field, Second column (right) is diff hours field..
They should have identic number formats
PD.- As an additional suggestion for the future, it would be good if in numerical fields cells you had the option of show blank cell (or empty) when the result to be displayed is (0) zero
regards
1.- In rows, data should be aligned to the right (However in total / average lower cell it's fine)
2.- In rows, decimals aren't show if the number is integer (However in total / average lower cell it's fine)
You can see the difference in the image. First column (left) is a formula field, Second column (right) is diff hours field..
They should have identic number formats
PD.- As an additional suggestion for the future, it would be good if in numerical fields cells you had the option of show blank cell (or empty) when the result to be displayed is (0) zero
regards
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: "Diff Hours" Type Field Error
Ok, clear.
Replace attached file includes\classes\fieldstypes\ieldtype_hours_difference.php
and unpack archive to css/ folder
then ctr+f5
Replace attached file includes\classes\fieldstypes\ieldtype_hours_difference.php
and unpack archive to css/ folder
then ctr+f5
- Attachments
-
- default.zip
- (6.87 KiB) Downloaded 250 times
-
- fieldtype_hours_difference.php
- (8 KiB) Downloaded 291 times
- elviseras
- Investor
- Posts: 578
- Joined: 08 Feb 2017, 03:16
- Name: Elvix Sampedro
- Location: Galicia - Spain
- Company Name: novaTEK
Re: "Diff Hours" Type Field Error
Now is perfect Sergey!!
Thank you very much for your quick support, as always
Thank you very much for your quick support, as always