We are experiencing problem that View is containing way too less records. Is there a way how to debug view and see what’s going on?
I would tipically genrate SQL code in ORIGAM Architect and debu it in MS SQL query analyzer. In ORIGAM 2018 there is even a SQL console, that allows SQL coding and returns result into Output.