Set Row Pagination As Select List In Interactive Grid Oracle APEX
- 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!
}
