Hi @Byron Plant
Yes it will happen with your current changes which you have made.
I have analyzed further on your code and you need to make couple of changes in order to have this working correctly.
1) First highlighting the Changes which need to be done in order in which I have made and then I will share the final version of the code as well:
a)
var CatQuery = "active=true" + "^ORopened_by=" + gs.getUserID();
var tableCatTask = "sc_task";
b) Added in Line Number 31
var CatCount = getCount(tableCatTask, CatQuery);
c) Added in Line Number 53
var catalog_link = '/id='+url+'New Page Name which you have to give here';
d) Added in Line Number 66
var CATTaskLabel = gs.getMessage("Catalog Task");
e) Added in Line Number 89 and 90
cat = {id: 7, label:CATTaskLabel, icon: 'fa fa-ticket',link:catalog_link,'count':CatCount, page :'New Page Name',visible:data.currentPage=='my_tickets'||data.currentPage=='my_requests'};
categories.push(cat);
Final Server script will look like below:
data.currentPage= $sp.getParameter("id");
//console.log(data.currentPage);
//badge datas
var incQuery = "active=true^caller_id=" + gs.getUserID() + "^ORopened_by=" + gs.getUserID();
var tableInc = "incident";
var CatQuery = "active=true" + "^ORopened_by=" + gs.getUserID();
var tableCatTask = "sc_task";
var watchQuery = "active=true^watch_listLIKE" + gs.getUserID();
var watchTable = "sc_req_item";
var reqQuery = "active=true^request.requested_for=" + gs.getUserID() + "^ORwatch_listLIKE" + gs.getUserID();
var reqTable = "sc_req_item";
var query = "approver=javascript:getMyApprovals()^state=requested^source_table!=change_request";
var table = "sysapproval_approver";
var surveyQuery = "userDYNAMIC90d1921e5f510100a9ad2572f2b477fe^state=wip^ORstate=ready";
var surtable = "asmt_assessment_instance";
var delegateQuery = "userDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORdelegateDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ends>=javascript:gs.beginningOfToday()";
var delegatetable = "sys_user_delegate";
var incCount = getCount(tableInc, incQuery);
var apprCount = getCount(table, query);
var reqCount = getCount(reqTable, reqQuery);
var watchCount = getCount(watchTable, watchQuery);
var surveyCount = getCount(surtable, surveyQuery);
var delegateCount = getCount(delegatetable, delegateQuery);
var CatCount = getCount(tableCatTask, CatQuery);
function getCount(table, query) {
var count= 0;
var rec = new GlideAggregate(table);
rec.addEncodedQuery(query);
rec.addAggregate('COUNT');
rec.query();
if(rec.next()){
count = parseInt(rec.getAggregate('COUNT'));
}
return count;
}
var url= (gs.getProperty('data.url.widget'));
var info_link= '/id=user_profile';
var req_link = '/id='+url+'my_requests';
var incident_link = '/id='+url+'my_incident';
var appr_link = '/id=my_approvals';
var watch_link = '/id='+url+'my_delegates';
var survey_link = '/id=my_surveys';
var catalog_link = '/id='+url+'New Page Name which you have to give here';
//Department items
var categories = [], cat;
//as part of LT
var requestLabel = gs.getMessage("REQUESTS");
var incLabel = gs.getMessage("Incidents");
var apprLabel = gs.getMessage("APPROVALS");
var survLabel = gs.getMessage("SURVEYS");
var profLabel = gs.getMessage("PROFILE");
var deleLabel = gs.getMessage("DELEGATES");
var CATTaskLabel = gs.getMessage("Catalog Task");
cat = {id: 1, label: requestLabel, icon: 'fa fa-shopping-cart',link:req_link,'count':reqCount,page:'my_requests',visible:data.currentPage=='my_tickets'||data.currentPage=='my_requests'||data.currentPage=='my_incidents'};
categories.push(cat);
cat = {id: 2, label:incLabel, icon: 'fa fa-ticket',link:incident_link,'count':incCount,page:'my_incident',visible:data.currentPage=='my_tickets'||data.currentPage=='my_requests'||data.currentPage=='my_incident;
categories.push(cat);
cat = {id: 3, label:CATTaskLabel, icon: 'fa fa-ticket',link:catalog_link,'count':CatCount, page :'New Page Name',visible:data.currentPage=='my_tickets'||data.currentPage=='my_incident'};
categories.push(cat);
if(gs.isLoggedIn() && (gs.getUser().hasRole('business_stakeholder') || gs.getUser().hasRole('approver_user') || gs.getUser().hasRole('itil'))){
cat = {id: 4, label:apprLabel, icon: 'fa fa-check-square-o',link:appr_link,'count':apprCount, page:'my_approvals',visible:data.currentPage=='my_approvals'||data.currentPage=='my_surveys'};
categories.push(cat);
}
cat = {id: 5, label:survLabel, icon: 'fa fa-question',link:survey_link,'count':surveyCount, page :'my_surveys',visible:data.currentPage=='my_approvals'||data.currentPage=='my_surveys'};
categories.push(cat);
cat = {id: 6, label:profLabel, icon: 'fa-info-circle',link:info_link,page:'user_profile',visible:data.currentPage=='user_profile'||data.currentPage=='my_delegates'};
categories.push(cat);
cat = {id: 7, label:deleLabel, icon: 'fa fa-list',link:watch_link,'count':delegateCount, page :'my_delegates',visible:data.currentPage=='user_profile'||data.currentPage=='my_delegates'};
categories.push(cat);
data.categories = categories;
data.myApprovals = getMyApprovals();
//console.log(data.myApprovals);
//console.log(data.categories );
Also couple of more things you need to look at to get this work correctly.
Navigate to Pages module and design a similar page as id ="my_incident" and replace it in the placeholder mentioned in updated script shared above.
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
