I was trying to check the data value for a DE with TEXT valueType in the Data Visualizer app. I noticed that the values have space added to the value as shown in the attached image. I have selected the Details only DISAGGREGATION when selecting the data.
When I checked the original value selected in the form, there is no space i.e Residing, Not Residing, CO instead of C O.
This is totally strange! Could you share the steps to reproduce in any of the play.dhis2.org instances? Maybe there are options to change that will display the text differently (and if not then maybe we can create a bug issue)?
@Gassim I checked the value in the database datavalue table and there is no space in the value. Here is another example. I am using a custom form and the value are selected from the form.
Is there a chance please to share steps to reproduce this issue in any of the play.dhis2.org instances so I could ask frontend team to test it and we can report it as a bug?
Unfortunately, I created the form with a custom app. So I don’t know how to reproduce the data in dhis2. However, when I use the search feature of the Data Visualizer app to search the DE name and select one DE, the value return without space as expected like the image below for comm1.
As I said the data is stored properly in the database and it appears without space individually.
But when I use the search feature of the Data Visualizer app to search data elements and select more than one DE in a pivot table, the value return with spaces. But if I select one data element, it returns without space.
That is the million question. The only difference I have noticed is that if I select more than one DE in a pivot table for details, the value return with spaces. But if I select one data element, it returns without space.
So I upload the updated app and check the data coming in the production instance. It happens that the space reappears. The production instance is on 2.39.0
My dev instance is on 2.39.0.2