Re: [Dhis2-users] SQL protected Table Issue

2018-09-12 Thread Jason Pickering
Hi John and Tuzo, While that may work, there are problems with that approach since during upgrades, that table may be modified, and if there is a view referencing it, the upgrade may fail. So, its not a recommended approach. These tables are "protected" because the API enforces various sharing an

Re: [Dhis2-users] SQL protected Table Issue

2018-09-12 Thread tuzo engelbert
Dear john, If you have access at the backend(server side) you might need to create view of that trackedentityattributevalue like create view te_trackedentutyattributevalue as select * from trackedentityattributevalue; And hence use view created in your sql Thanks On Tue, 11 Sep 2018, 4:54 p.m.