Re: [Dhis2-devs] SQL query contains references to protected tables error

2017-07-26 Thread Jason Pickering
Hi Pooben, I suspect (but not sure) this has to do with a change made here https://github.com/dhis2/dhis2-core/commit/5e1cc7c7820950f6540e8e2f1c465ac321e26045 which strips newline characters from SQL queries. This was a weakness which was corrected. The "Trackedentity" tables are considered to

[Dhis2-devs] SQL query contains references to protected tables error

2017-07-26 Thread Pooben Dass
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 "Syst