Analytics Tables Column Names

Support - Assistance technique
1

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
FROM public.analytics_enrollment_mjhhsinlcfl;

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?

Thanks.

4 Likes
2

Hi @WaluQ,

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.

Best,
James.

1 Like
3

The @dhis2-analytics team is still on break? Ill really appreciate feedback on this. Thanks.

1 Like
4

Hi @WaluQ,

Sorry for taking quite long to get back to you. I have 2 questions first;

  1. Which version of dhis2 are you using?
  2. Is it a custom table or a system table?

Best,
James.

1 Like
5
  1. 2.28
  2. System table(s)
1 Like
6

@WaluQ

Kindly query the Data Element Structure Table for the dataelementuid and the dataelementname

Try using this Query:

SELECT dataelementuid,dataelementname FROM public._dataelementstructure WHERE dataelementuid = 'YOUR UID'

Let me know if this works.

Best,
James.

5 Likes
7

Many thanks @jomutsani, thats exactly what I was looking for. Greatly appreciated.

3 Likes
8

Always happy to help @WaluQ! :smile:

Best,
James.

2 Likes