@ronald28659 Sorry. You explained it perfectly in the first post. I didn’t read it carefully.
But the offerte _id value in the first example (with the include method) is not the same as in your direct query test. So maybe item 414ae9b0-f4ea-498b-ba09-5ecc2bbfc450 just doesn’t have a defined value for these fields. Are you sure they’re filled in (not only in live collection)?