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.
Right, thanks! Then maybe it’s something that you can tweak in your app?
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.
Okay, thanks! But if it’s stored exactly the same way as other data values, why do you think these ones are being retrieved differently?
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.
Thanks for reporting! This is a bug and is being followed by the developers. [DHIS2-14172] - Jira
Would you please check for the API responses? The analytics and the metadata part of the response?
@jetisco4u in which version of DHIS2 are you seeing this?
Thanks for creating this in a Jira. I will follow the update.
By the analytics and the metadata part of the response do you mean I should check my backend log?
Thanks! I mean the API endpoints, analytics endpoints and metadata endpoint both of which you will find in the Networks tab (F12 → Network)