Solved

Cubic meter in grid displays different when deployed than in local environment

  • 18 May 2023
  • 5 replies
  • 58 views

Userlevel 1
Badge +4

Hey all,

I am having an issue.

i concatenated a value with cubic meters but i am having an issue with displaying it in my grid.
When i look at it in my local environment it displays correct:

these are the values in my database:


But when i deploy it, it looks like this:
 

Any idea what could be causing the issue?

icon

Best answer by Timothy Mentowidjojo 23 June 2023, 12:51

View original

This topic has been closed for comments

5 replies

Userlevel 1
Badge +4

Hey @Mark Jongeling,

It looked fine in the functionality screen and generate source code process but not in the devops repo. We are using 2023.1.12.0. We settled with using m3 and ft3 instead.

 

Userlevel 1
Badge +4

btw the values from my database are from a view and the values that are displayed in the grid are via a lookup

Userlevel 7
Badge +23

Hi Timothy,

Is the column in the View a Nvarchar? Whilst the model may say it should be a Nvarchar, the View code on the database may return data as Varchar. Casting the column as Nvarchar will solve that. 

Hope this does the trick!

 

Userlevel 1
Badge +4

Hey @Mark Jongeling , that didn’t help.

I provided you with the view below. An extra character gets put after deployment which is weird.

Userlevel 7
Badge +23

Hi Timothy, 

It looks to be that when generating the code of the View that the encoding is the problem. Do you use the Functionality screen or the Generate source code process? In my test in the upcoming 2023.2, I do see the correct result.