(function() { /* populate the 'data' object */ /* e.g., data.table = $sp.getValue('table'); */ // data.status='state'; // data.des='desc'; // data.num='numb'; // data.date='dat'; if (!options.maximum_entries){ options.maximum_entries = 3; var gr = new GlideRecord('sc_request'); var gi = new GlideRecord('incident'); gr.addQuery('opened_by',gs.getUserID()); gr.addQuery('active', 'true'); gr.orderByDesc('sys_created_on'); gr.query(); gi.addQuery('opened_by',gs.getUserID()); gi.addQuery('active', 'true'); gi.orderByDesc('sys_created_on'); gi.query(); data.count = gr.getRowCount(); data.count1 = gi.getRowCount(); data.list = []; var recordIdx = 0; while (gr.next()) { if (recordIdx == options.maximum_entries) break; var record = {}; var STATUS = gr.getDisplayValue('request_state'); var DESCRIPTION = gr.getValue('short_description'); var NUMBER= gr.getValue('number'); var DATE=gr.getValue('opened_at'); record.status=STATUS; record.description=DESCRIPTION; record.number =NUMBER; record.date =DATE; data.list.push(record); } data.list1 = []; var recordIdx1 = 0; while (gr.next()) { if (recordIdx1 == options.maximum_entries) break; var record1 = {}; var STATUS1 = gr.getDisplayValue('u_request_state'); var DESCRIPTION1 = gr.getValue('short_description'); var NUMBER1= gr.getValue('number'); var DATE1=gr.getValue('opened_at'); record1.status=STATUS1; record1.description=DESCRIPTION1; record1.number =NUMBER1; record1.date =DATE1; data.list1.push(record1); } } })();