Divergent data when using projection

Hello everyone, how are you?

I started having problems in my environment, some collections have shown the following behavior:
When making a query the document returns the data, but for some fields if I project it into the query it does not bring the correct data, or an empty value “” is presented or it brings information different from that present in the document.

I duplicated the collection to test some points but this new one does not present the problem, it works properly.

I understand that it is a serious case not to read the data or to read the data with a different value.

Any suggestions as to what might be happening?

Thanks.

Hi @Daniel_Rocha_Oliveira,

Welcome to the MongoDB Community :wave:

Can you share your documents and the query with both collections and results here if it’s possible?

Best,
Shreya