In case of paging with Table Record Aggregates fetching records according to line count from database but in case of advance sql it is fetching all records from database every time. In this demo I done the implementation so that advance sql is also fetching data as per line count of table record(same way Aggregates in case of paging). It will improve the performance of advance sql.

This is fully customized and flexible confirmation popup and can be used in reactive application. 

Problem Statement: When we need to export entity data into excel then Excel header will be exact same what is entity attribute name like attached problemstatement.jpg I used advance excel and created a logic within service action to customize the excel header names as required without impacting existing code like as attached CustomizedExcelHeader.jpg