I was digging a bit deeper (was just about to post a new topic).
This happens when it’s filtered on a reference field. So, say, if I have 2 tables: Employees and Departments, and an Employee has a reference field to Department, then when I update the Employee record, it breaks the reference, even though I set the same reference data (id and name for the department).
That’s causes the filter to exclude that row.
So, the real issue is how to keep the reference field during an update without breaking it.
If I explicitly delete that reference property from the updated object - that works, but that’s a pain to do across the board, and it doesn’t allow updating the reference itself (like changing departments) - I’d much rather return the full object that originally created the row.