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
Thanks and Regards
Mithilesh Kumar Thakur