This message and any attachments are subject to a disclaimer published at 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@hisp.org 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.
which strips newline characters from SQL queries. This was a weakness which was corrected.
The “Trackedentity” tables are considered to be protected, mostly because they could contain reference to personally identifiable information.
I am not sure, but suspect that your SQL query had new line characters, and even though it should not have worked in 2.25, it did, due to this weakness.
Hope that helps.
Regards,
Jason
···
On Wed, Jul 26, 2017 at 12:51 PM, Pooben Dass pooben@hisp.org wrote:
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
This message and any attachments are subject to a disclaimer published at 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@hisp.org 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.