Perform On Table - Select operation is not working as expected

Summary

Perform On Table - Select operation is not working as expected

Content

Hi ,

I am trying to fetch data from two tables. I am doing it with "Perform operation on table " option with select operation. 

Problem is it's always fetching the child table data for 1st parent table record. For other Parent table records, I am getting child table data as blank.

Data is available in the table.

Attaching a sample file. invBalanceTxnsLotIntCollection_2 is coming as NULL for snapshotId '60509'. Data is availble in child table.

 

Thanks,

Priyanka

 

Is there any setting needs to be done while configuring t he DB adapter? Kindly provide your inputs.