Feedback on Automating Materialized View Refresh in DHIS2 Scheduler App

Implementation - Implémentation
1

Hello DHIS2 Community,

I’ve been working on enhancing performance in our DHIS2 instance by leveraging materialized views. These views are great for optimizing queries, but they require periodic refreshing to stay up-to-date. Currently, DHIS2 allows us to manually refresh materialized views or use the API (e.g., api/29/sqlViews/{view}/refresh) to trigger the refresh.

However, I noticed that the Scheduler app does not include an option to automate the refresh of materialized views. I believe having this functionality integrated would significantly improve workflows by eliminating the need for manual API calls.

Before submitting a formal feature request, I wanted to reach out to the community to gather feedback. Has anyone faced a similar situation, or implemented a solution to automate materialized view refreshes? I’d love to hear your thoughts and suggestions.

Thank you in advance for your input!

Best regards,
Tafsir

1 Like
2

Add this feature request to JIRA: [DHIS2-17911] - Jira

2 Likes
3

Hi @diallotafsir52

It is really great that you are reaching to share with other community members the feature request. It could indeed be found necessary or helpful by others. Please remember that for feature requests and getting votes for these features there’s a new voting tool that is directly part of the software roadmap. You can read more about this in ideas

Thanks!