Set Row Pagination As Select List In Interactive Grid Oracle APEX

Set Row Pagination As Select List In Interactive Grid Oracle APEX 

s
  • 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
  • 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!
}


 Demo