HTML
<button class="btn btn-primary" ng-show="c.data.current_page != 0" ng-click="getPreviousIdx()">Previous</button>
<button class="btn btn-primary" ng-show="c.data.count >= c.data.page_size" ng-click="getNextSetIdx()">Next</button>
Client Script
// pagination
$scope.getNextSetIdx = function(idx) {
c.data.current_page = parseInt(c.data.current_page) + 1;
c.data.action = "nextRecordIdx"
c.server.update().then(function(r){
c.data.action = undefined;
});
}
$scope.getPreviousIdx = function(idx) {
c.data.current_page = parseInt(c.data.current_page) - 1;
c.data.action = "nextRecordIdx"
c.server.update().then(function(r){
c.data.action = undefined;
});
Server Script
if (!input) {
//data.records = [];
data.page_size = 5;
data.count = 5;
data.current_page = 0;
data.approvals = [];
var approvalGR = new GlideRecord('sysapproval_approver');
approvalGR.addQuery('state', 'Requested');
approvalGR.addQuery('approver', gs.getUserID());
approvalGR.addQuery('source_table',"!=", "");
approvalGR.orderBy('sys_created_on');
approvalGR.chooseWindow(data.current_page, data.page_size);
approvalGR.query();
}
}
if (input && input.action == "nextRecordIdx") {
//data.records = [];
data.count = 0;
var startPage = input.current_page * input.page_size;
var endPage = (input.current_page * input.page_size) + input.page_size;
data.approvals = [];
var approvalGR = new GlideRecord('sysapproval_approver');
approvalGR.addQuery('state', 'Requested');
approvalGR.addQuery('approver', gs.getUserID());
approvalGR.addQuery('source_table',"!=", "");
approvalGR.orderBy('sys_created_on');
approvalGR.chooseWindow(startPage, endPage);
approvalGR.query();
while(approvalGR.next()){
data.count++;
}
else{ return data}
}
}
});Thanks for the reply, to be honest, I'm confused with your code, will try to understand it fully.
Here's my situation, I'm creating pagination functionality inside a widget as above, I took some help for this code from communinty : https://community.servicenow.com/community?id=community_blog&sys_id=4cac2225dbd0dbc01dcaf3231f96198b
I've created a widget which has 3 sections inside it, first to show pending approvals, second to show approval history, and a third custom approvals section.
Now by using this above functionality, I was able to paginate the first section(pending approvals), and using the same functions with different variables I'm trying to paginate the next section i.e Approval History,
The problems which I'm facing with the second section are:
When the page loads for the 1st time, it only shows the next buttons, but no records, i need to click the button once to get the records.
When I click the next button, records are getting fetched properly, but the list of records changes between 1 to 5, I want constant 5 records to show.
1st time on loading : -
when I press Next : 4 records
when I press Next for second time : 1 record
Please suggest something.
Thank You.
- Laukik
