dhis2-devs team mailing list archive

[Mithilesh Kumar Thakur <mithilesh.hisp@xxxxxxxxx>]

Dear Devs

I am try to write query in SQL view but it is not working is show the alert
like "SQL query contains references to protected tables" is there is any
specific reason for  protect the tracker related tables?

Is it possible to overwrite if yes then how it possible.

The query which i am writing in SQL View are as follows

SELECT tei.organisationunitid,count(tei.trackedentityinstanceid) from
trackedentityinstance tei inner join trackedentityattributevalue teav on
tei.trackedentityinstanceid = teav.trackedentityinstanceid  group by
tei.organisationunitid

and more



-- 

Thanks and Regards

Mithilesh Kumar Thakur