Hi,
I have this setup
I want the case table to show all the records inside of it - Please note that I already have the 'left join' as true ...
How can I achieve it - If it is possible
I attempted to re-create this in my PDI. In a scoped app table I added a column that's a reference to the case table then setup the Left join and Where clause I suggested where case_sys_id=<<my table column>>. I was only seeing the 5 records I created in the scoped app, 4 of which had the case reference column populated - which would be a left join on the custom table. I switched the order to put case first, with the Where clause on the 200/custom table and it works as expected.
I attempted to re-create this in my PDI. In a scoped app table I added a column that's a reference to the case table then setup the Left join and Where clause I suggested where case_sys_id=<<my table column>>. I was only seeing the 5 records I created in the scoped app, 4 of which had the case reference column populated - which would be a left join on the custom table. I switched the order to put case first, with the Where clause on the 200/custom table and it works as expected.
