Hi,

I have a situation where we do server side pagination to load UI grid data. Data is present in staging tables in DB.

Header (parent)
->Lines (child) one to many
-> Udf (child) one to many

I need to fetch one parent (header) object whose child (lines) might have n number of objects but i should only fetch first 25 objects based on the serial number of Lines object. along with that i should also fetch the respective Udf objects for all the 25 lines also.

Please advice me the best approach to achieve this.

You can use a DTO for the UI. The DTO could have the parent entity. Then you select max N Lines with a separate query that joins with UDF too.