How to resolve a bug where documets and media files are not indexed to MediaStorage

I have encountered a problem with several file managers which I have failed to resolve. Files in my device are not properly indexed and hence are not recognised by the file managers at least to my understanding. Instead of choosing a desired category in the file manager e.g documents or video etc, it shows as empty yet have several files of that type. I have to manually dig through the internal Storage to find the specific file see image: I understand in some devices running MIUI, the culprit apps usually are Downloads and MediaStorage so I have wiped their data and even uninstalled updates yet the problem still persists. Funny the problem does not in second space (multi user space), anything that I am missing. *Android 9, MIUI 11 Xiaomi Redmi Note 4 (mido)*