A report filter rewrites FIELD names to their qualified physical columns, but a bare to-one RELATION name (Status != 8) passed through verbatim - the generated query carried a nonexistent column and failed at SQL time, with every generation step green. Bare to-one relation names must rewrite to the FK column (Invoice."INVOICE_STATUS" != 8), leaving the dotted-ref pass's join-alias tokens intact.
Retrospective issue for traceability.
A report
filterrewrites FIELD names to their qualified physical columns, but a bare to-one RELATION name (Status != 8) passed through verbatim - the generated query carried a nonexistent column and failed at SQL time, with every generation step green. Bare to-one relation names must rewrite to the FK column (Invoice."INVOICE_STATUS" != 8), leaving the dotted-ref pass's join-alias tokens intact.Retrospective issue for traceability.