/ #APEX #PLSQL 

Set Row Pagination As Select List In Interactive Grid Oracle APEX

Set Row Pagination As Select List In Interactive Grid Oracle APEX

Set Row Pagination As Select List In Interactive Grid Oracle APEX Setup

  • 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

Image 1

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

Image 1 Demo