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”