Have the below basic select query from one of the analaytics tables of interest:
Select uidlevel5, daily, “buawW4H8IyI_ZBZbGcveY7K”,…, “VlCpP6EXnSz_dZnGc0Il2Ew”, “VlCpP6EXnSz_sJIs5uhtLoJ”, enrollmentdate, ou, ouname, oucode, tei
Is there a table has have the actual dataelement names for the elements which are coded like buawW4H8IyI_ZBZbGcveY7K etc? Is there a way to join these codes to normal names without manually creating aliases for them?
As other members get to have a look at this and give their insight, the @dhis2-analytics team will also check and revert on the same.
The @dhis2-analytics team is still on break? Ill really appreciate feedback on this. Thanks.
Sorry for taking quite long to get back to you. I have 2 questions first;
- Which version of dhis2 are you using?
- Is it a custom table or a system table?
Kindly query the Data Element Structure Table for the
dataelementuid and the
Try using this Query:
SELECT dataelementuid,dataelementname FROM public._dataelementstructure WHERE dataelementuid = 'YOUR UID'
Let me know if this works.
Many thanks @jomutsani, thats exactly what I was looking for. Greatly appreciated.
Always happy to help @WaluQ!