Welcome to the community! Was the solution provided by @Ulanbek successful?
I have not been able to replicate any of the issues mentioned above. Probably updating to 2.37.9 and clearing server and browser cache should solve the issue.
No, clearing the cache and reloading apps on Data Administration, did not work for us. We did not consider upgrading DHIS as with same/similar DB and same DHIS version in two servers. This issue is reproducible in one server and not in other server.
Maybe this is a DB issue? Could you check for duplicates directly in the DB? If there are duplicates in the DB then they should probably be removed. Make sure to back up before testing. Thanks!
With larger page size, we can get all the results in one page and i don’t see any duplicates in that single page response. So, i am not expecting any duplicates in DB. But i will check from DB side once.
Everything looks okay from DB side. I was able to reproduce the issue in other server also by restoring it with the DB of server which has the issue.
Also saw the code and figured out that pagination is done by adding limit and offset to the query. Results can be repeated by just adding limit & offset and it is recommended to have order by to get results without duplicates based on sql - PostgreSQL - repeating rows from LIMIT OFFSET - Stack Overflow.
I have added “order” api query param as “order=event” and things started working as expected / I don’t see any duplicates after adding “order” query param to the API.
Great news to hear and happy you found the solution. Thank you so much for sharing the solution with the community! If the topic is solved please select the post that solves the problem (your last post probably.)