Hey Gil, I think I did you a disservice by not connecting this comment well enough: https://github.com/xtuple/xtuple/pull/1493/files#r12769838. We are using a where clause, but seemingly inconsistently.