Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

issue with null values on string dataType

Answered
Serkan asked on April 3, 2020

Dears,
 
Flexmonster shows null values as “null” when dataType is string. Although I set the format for nullValues, it shows “null” instead of set value.
Please check the example -> http://jsfiddle.net/sekoooy/3ynowtm4/37/ 
 
Best regards,
Serkan

6 answers

Public
Vera Didenko Flexmonster April 3, 2020

Hello, Serkan,
 
Thank you for writing to us.
 
We would like to explain that the format object defines the way how numeric values are formatted in the component. 
 
For customizing the way empty string values are shown on the grid, we kindly recommend using localization:

global: {
localization: {
grid: {
blankMember: "test"
}
}
}

Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/f2ck46b1/
 
 
Please let us know if everything works fine for you.
 
Best regards,
Vera
 

Public
Serkan April 4, 2020

Hello Vera,
Thank you for blankMember explanation but this is not fixed my issue.
We have some null data on string dataType column. Is there any way to show null values on string dataType column instead of “null”?
 
Best regards,
Serkan

Public
Vera Didenko Flexmonster April 6, 2020

Hello, Serkan,
 
Thank you for your response.
 
Our team will provide an update so that null and undefined values for fields of type string will be considered as blankMember
Then it will be possible to customize null value representation for string data types via localization as shown in the previous answer.
This will be available in the minor release version with the ETA 4th of May.
 
Meanwhile, as a workaround, we kindly recommend changing the displayed "null" values via the customizeCell() API call.
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/h82gctv3/
 
Please let us know if this would work for you and if you have any additional questions.
 
Looking forward to your reply.
 
Kind regards,
Vera

Public
Serkan April 6, 2020

Hello Vera,
 
Thank you for your response. We can use workaround until minor release is available.
 
Best regards,
Serkan

Public
Vera Didenko Flexmonster May 5, 2020

Hello, Serkan, 
 
We are happy to inform you that now the nullValue format object property works for string data types also. 
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/aLmhrxye/
 
This is provided in the 2.8.6 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
 
Please let us know if everything works fine for you. 
Looking forward to your feedback. 
 
Kind regards, 
Vera

Public
Serkan May 6, 2020

Hello Vera,
 
I implemented and tested the 2.8.6 version that everything works well. Thank you very much!
 
Best regards,
Serkan

Please login or Register to Submit Answer