laptop and a wrench

Bogue

When using an SQL expression in ArcGIS Online, text fields calculated from double fields round or convert the numbers to scientific notation when there are more than seven digits in the double record.

ArcGIS Online
Numéro d’ID de bogue BUG-000143171
EnvoiSeptember 23, 2021
Dernière modificationSeptember 2, 2025
S’applique àArcGIS Online
Version trouvée9.2
Système d’exploitationWindows OS
Version du système d’exploitation10.0
StatutAs Designed

Informations supplémentaires

In ArcGIS Online, esriFieldTypeDouble maps to SQL Server float. Float provides up to 15–16 digits of precision. Values beyond this limit will either render in scientific notation (for large integers) or truncate extra fractional digits. This aligns with documented SQL Server behavior in Microsoft Docs for float and real (Transact-SQL) in https://learn.microsoft.com/en-us/sql/t-sql/data-types/float-and-real-transact-sql?view=sql-server-ver16.

Solution de contournement

Use Arcade expressions when calculating text fields from doubles to preserve the full literal value. For SQL calculations, the str (length, decimals) function can control formatting, though precision remains limited by float. If exact preservation of all digits is required, consider using text or decimal/numeric fields instead of double.

Étapes pour reproduire

ID de bogue: BUG-000143171

Logiciel:

  • ArcGIS Online

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement