← Back to team overview

dhis2-devs team mailing list archive

pivot table queries and resource tables

 

Hi Ola

Quick question:

the resource table _dataelementgroupsetstructure lists all
dataelementnames.  Similarly with _indicatorgroupsetstructure,
_orgunitstructure and _orgunitgroupsetstructure.

In the pivot views you are familiar with, should it be necessary to
also have access to dataelement, indicator and orgunit tables or are
the resource tables sufficient?

If not, could/should we make it so?  eg to bring shortnames into these
tables if they are used.  Or, if it is desirable to be able to use the
"source" tables, to remove the names from the resource tables?

Regards
Bob



Follow ups