Question

Different decimal places returned for a field across the environments

  • 20 November 2023
  • 2 replies
  • 36 views
A
Rank
Userlevel 1
Badge +8

Hello FSM experts,

 

I’m facing a problem where a certain field returns 10 decimal places when the table is queried in the Production environment where as the same field returns 0 decimal places across the other environments (TEST and DEV)

PROD:

TEST and DEV:

 

The custom metadata and the table script for this field is identical across the environments

 

seems like the mask type is ignored by the server in Prod.

Note: No decimal places are shown in the UI across all the environments.

 

Appriciate your help regarding this issue.

 

Kind regards,

Anupama Nagahawatta

2 replies

Shneor Cheshin
Rank
Userlevel 6
Badge +26

Hi @AnupamaHN 

Besides the fact that SQL script returns an INT vs a DECIMAL.

What is the issue?

Cheers!

A
Rank
Userlevel 1
Badge +8

Hi @Shneor Cheshin 

Returning different values (with different decimal places) causes an issue with regard reporting. Because different results are returned in report data. So the value returned to this field should be consistent across the environments.

Kind regards,

Anupama Nagahawatta

Reply


Terms & ConditionsCookie settings