Set Row Pagination As Select List In Interactive Grid Oracle APEX

Set Row Pagination As Select List In Interactive Grid Oracle APEX

Preview

• I have Created an Interactive Grid using the following SQL Query.

select ID,
NAME,
LOCATION,
COUNTRY
from DEPARTMENTS

• Interactive Grid Attribute as per screenshot: 

Pagination:=   Type => Page
Show Total Row Count => YES

Screenshot

• Copy and Paste bellow JavaScript Code in Interactive Grid Attribute JavaScript Initialization Code section as per Screenshot:

function(config) {    config.defaultGridViewOptions = {
        rowHeader: "sequence",
        pagination: {                                         
            showRange: true,
            showPageSelector: true,
            showPageLinks: false,
        }
    };
    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!
}

Grid JavaScript

Demo

Add Custom Button To Load More Records from Interactive Grid In Oracle APEX