nVision with outer joined query prompts is dropping values the query does not drop
edited Oct 3, 2018 1:05PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓
I have a layout with ledger data via Matrix on one tab and query results via Tabular on another tab. The scope criteria is project ID driven.
The underlying query is outer joined to retrieve any dollar amounts that match the criteria. The query prompts on accounting date within the out joined data set.
The query produces results across all projects with a blank dollar amount where expected for those without payments.
The nVision report produces blank query data on the projects where no payment data exists as though it is ignoring the outer join.
Anyone else experiencing this or who can advise?
0