Bug ID Number |
BUG-000125547 |
Submitted | September 25, 2019 |
Last Modified | July 28, 2020 |
Applies to | Portal for ArcGIS |
Version found | 10.7.1 |
Status | In Review
The issue is being reviewed. The review process ensures that the issue contains all necessary information and is easy to understand, that it is not a duplicate of an existing issue, and that it is a valid bug or enhancement request. During this phase, it is possible that you are contacted for clarification or additional information.
|
Workaround
Use the CAST function in the Query Layer SQL statement, and change the REAL data type field to Float data type.
For example:
- Select Scada_Tag, DateTime, CAST (Most_Recent as float) as Most_Recent from scadadata.dbo.Scada_Most_Recent_vw
- Then in ArcMap > Scada_Most_Recent_vw set the decimal values on the Most_Recent (Right-click the field > Properties > Numeric > (Number of decimals places: 2).
- Publish the map service to Portal for ArcGIS.
Steps to Reproduce