Skip to main content

Posts

Showing posts from January, 2020

Load more row option in Oracle APEX 18.2 Interactive Grid (IG)

Objective: To bring partial data refresh concept to improve the query (data retrieval) performance in Interactive Grid. Solution: Step 1:   Create Interactive Grid Report. Step 2:  Do the below attributes setting. Pagination: Type => Scroll Show Total Row Count => NO Heading: Fixed To => Region Fixed Report Height => {as per your requirement} Step 3:  Add the below JS in the JS section of the IG attributes. function(config) {     config.defaultGridViewOptions = {         rowHeader: "sequence",         pagination: {             loadMore: true         }     };     config.defaultIconViewOptions = {         collectionClasses: "t-Cards t-Cards--compact t-Cards--displayIcons u-colors t-Cards--desc-2ln"     };     return config; // don't forget to return this! } Step 4:  Add the below HTML in the footer section of the IG region. (To indicate user) < span style = "color:block;font-weigh