Hi,
This is related to a bug with analytics and sql views that was initially fixed
but seems to have crept in again. It will need to be fixed – A temporary
workaround is to delete sql views from your database.
Regards,
Dapo Adejumo
+2
Hi Emmanuel,
It is not possible to have views linked directly to the resource tables, as
they are dropped and regenerated each time when the analytics runs.
Two options.
1) Encapsulate your view in a stored procedure.
2) Use the SQL view function of DHIS2.
Both approaches have been discussed pre
2 matches
Mail list logo