Possible to replace visualisation query?

After we design a visualisation we can export the SQL command. We see that the SQL is inefficient and we can write a better one which will give expected results or will execute faster.

Is there a way to replace the query inside database so that the visualisation uses the new query? Or is there a possibility that from custom DHIS2 app we replace the query and execute the visualisation?

@jen.jones.arnesen @jan @martin or @edoardo could you answer this question?

Hi @Mahmud
As far as I know you can’t replace sql queries without forking the backend. Would you like to tell us more about how you think it can be improved?

1 Like