From within the Service Portal, if I click on Requests from the top nav bar and select 'View all requests,' I am taken to the request page that displays my open incidents and requests. Currently, the 'My Incidents' section sorts by the sys_updated_on field. I want this list to sort by the sys_created_on field. I thought I could achieve this by editing the Requests menu item from the 'SP Header Menu' parent menu, but my edits had no effect. What am I doing wrong or am I approaching this incorrectly?
// maximum number of entries in this Menu
var max = 30;
var t = data; // shortcut
t.items = [];
var u = gs.getUser().getID();
// use record watchers to tell header when to update dropdown counts
t.record_watchers = [];
t.record_watchers.push({'table':'service_task','filter':'active=true^opened_by=' + u});
t.record_watchers.push({'table':'incident','filter':'active=true^caller_id=' + u});
t.record_watchers.push({'table':'sc_request','filter':'active=true^requested_for=' + u});
var st = new GlideRecord('service_task');
if (st.isValid()) {
st.addActiveQuery();
st.addQuery('opened_by', gs.getUserID());
//st.orderByDesc('sys_updated_on');
st.orderByDesc('sys_created_on');
st.setLimit(max);
st.query();
while (st.next()) {
var a = {};
//$sp.getRecordValues(a, st, 'short_description,sys_id,number,sys_updated_on');
$sp.getRecordValues(a, st, 'short_description,sys_id,number,sys_created_on');
if (st.short_description.nil())
a.short_description = "(No description)";
a.__table = st.getTableName();
a.type = 'record';
//a.sortOrder = st.sys_updated_on.getGlideObject().getNumericValue();
a.sortOrder = st.sys_created_on.getGlideObject().getNumericValue();
t.items.push(a);
}
}
var z = new GlideRecord('incident');
z.addActiveQuery();
z.addQuery('caller_id', gs.getUserID());
//z.orderByDesc('sys_updated_on');
z.orderByDesc('sys_created_on');
z.setLimit(max);
z.query();
while (z.next()) {
var a = {};
//$sp.getRecordValues(a, z, 'short_description,sys_id,number,sys_updated_on');
$sp.getRecordValues(a, z, 'short_description,sys_id,number,sys_created_on');
if (z.short_description.nil())
a.short_description = "(No description)";
a.__table = z.getTableName();
a.type = 'record';
//a.sortOrder = z.sys_updated_on.getGlideObject().getNumericValue();
a.sortOrder = z.sys_created_on.getGlideObject().getNumericValue();
t.items.push(a);
}
var z = new GlideRecord('sc_request');
z.addActiveQuery();
z.addQuery('requested_for', gs.getUserID());
//z.orderByDesc('sys_updated_on');
z.orderByDesc('sys_created_on');
z.setLimit(max);
z.query();
while (z.next()) {
var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('request', z.getUniqueValue());
ritm.query();
if (!ritm.next())
continue;
var a = {};
//$sp.getRecordValues(a, z, 'sys_id,number,sys_updated_on');
$sp.getRecordValues(a, z, 'sys_id,number,sys_created_on');
if (ritm.hasNext())
a.short_description = ritm.getRowCount() + ' requested items';
else
a.short_description = ritm.cat_item.getDisplayValue() || ritm.getDisplayValue("short_description");
a.__table = z.getTableName();
a.type = 'request';
//a.sortOrder = z.sys_updated_on.getGlideObject().getNumericValue();
a.sortOrder = z.sys_created_on.getGlideObject().getNumericValue();
t.items.push(a);
}
t.items.sort(function(a, b) {
return b.sortOrder - a.sortOrder;
});
t.items = t.items.slice(0, max); // only want first 30
t.count = t.items.length;
var link = {title: gs.getMessage('View all requests'), type: 'link', href: '?id=requests', items: []};
t.items.unshift(link); // put 'View all requests' first
