Outer join not pulling through all incidents - just where they have a relationship to an incident
Content
Hi,
So:
- Added a incident reference
- Added transaction type
- Added transaction id3
- Did outer join
- Filtered transactions on type =**** and id3 in A,B,C
The resulting report only shows where an incident matches with the relevant transaction but I also want to show incidents where a transaction doesn't exist for these filters (null). How would I go about this?
So:
- Show all incidents (with incident filters applied) whether or not the transactions (filtered) exist
Tagged:
1