dhis2-devs team mailing list archive

[Pooben Dass <pooben@xxxxxxxx>]

I'm trying to create a SQL view in dhis 2.27 but I keeping receiving this
error SQL query contains references to protected tables?
Any idea why as I was able to create the view in dhis 2.25 previously and
how can i recreate it

Here is my select


SELECT
  trackedentityattributevalue.value AS "SystemResolutionNumber",
  trackedentityinstance.uid AS "TrackedEntityInstanceUID",
  trackedentityinstance.trackedentityinstanceid
FROM
  public.trackedentityinstance,
  public.trackedentityattribute,
  public.trackedentityattributevalue
WHERE
  trackedentityattributevalue.trackedentityinstanceid =
trackedentityinstance.trackedentityinstanceid AND
  trackedentityattributevalue.trackedentityattributeid =
trackedentityattribute.trackedentityattributeid and
  trackedentityattribute.name like 'System Resolution Number';

Regards
Pooben

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
<http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclaimer@xxxxxxxx 
<disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*