This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Can anyone give me an idea around resolving an issue. We are implementing Maximo Mobile and when users log time on the devices to specific work orders, the decimal values for the time logged that are importing to Maximo are rediculously long... (Ex. 1.7587382 hours)...
We are looking for a way to round this value to one decimal value so when the data uploads to Maximo, it would need to change to 1.8 hours. Has anyone done anything along these lines and if so, how did you accomplish it?
I look at database config to change the length of the regularhrs field in the labtrans table but this field is not editable. I also explored escalations but did not find an option for doing something like this...
I suspect I could insert SQL somewhere in my process either as a stored procedure or chron task but am wondering if this is the best option and how a more seasoned user might attack this...
SQL...
UPDATE labtransc
SET regularhrs = round(regularhrs,1)
Thoughts? Any input is GREATLY appreciated.
Keith