<{{Subtitle_Weight}} class="prominent-subhead {{Show_Subtitle}}"> {{Header_Subtitle}}

Code Fix: After upgrading to K2 4.7, decimal values are displayed with multiple zeros on a view

~~repeating-content.html~~
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Issue Description

After upgrading to K2 4.7, where a list view contains a column returning decimal values, the values are displayed with multiple zeros at the end of the value. For example:

  • 3.11 will display as 3.110000000

This issue is related to a SQL service instance SmartObject based on a Stored Procedure as well as a WCF service instance SmartObject

Resolution

  1. Ensure you have K2 4.7 installed.
  2. Download and Install the K2 4.7 November 2017 Cumulative Update from K2 Partner and Customer Portal.
  3. Get the K2 4.7 November 2017 Cumulative Update FP14 from Regional Support.
  4. Install the K2 4.7 November 2017 Cumulative Update FP14 to apply the fix.
  5. When using a SQL service instance SmartObject, refresh the service instance and regenerate the SmartObject.
  6. When using a WCF service instance SmartObject, add the following to the sourcecode.smartobjects.runtime attributes in the K2HostServer.exe.config file:

     disabledecimalprecision=”true”