How to get RITM & Catalog Item details from sysapproval_approver user Based

ronaldanand · ‎06-05-2019

Hi all

How to fetch the details from sysapproval_approver table based inactive user Pending Approval Items

I need to display RITM, Catalog Item and Approver details, I Used below script but RITM & Ctalog item not displaying Properly ,Kindly check and help me to fix this issue

    var sysapprv = new GlideRecord('sysapproval_approver');
   sysapprv.addQuery('state', 'Requested');
   sysapprv.addQuery('source_table', 'sc_req_item ');
   sysapprv.addQuery('approver', '68e87eab0ff9310039190bcce1050e7b');
   sysapprv.query();
   var counts = sysapprv.getRowCount();
   gs.print('andrewww---->'+counts);

if( counts > 0)
{

   while (sysapprv.next())
   {

       gs.print('RITM'+ sysapprv.number.getDisplayValue());
       gs.print('ITEM'+ sysapprv.cat_item.name.getDisplayValue());
gs.print('Approver'+ sysapprv.approver.getDisplayValue());

   }
   }

Thanks

Mike Patel · ‎06-06-2019

Below worked for me to get value but not count.

var sysapprv = new GlideAggregate('sysapproval_approver');
sysapprv.addQuery('state', 'requested');
sysapprv.addQuery('sysapproval.table', 'sc_req_item');
sysapprv.addQuery('approver', '68e87eab0ff9310039190bcce1050e7b');
sysapprv.query();
var counts = 0;
if(sysapprv.next()){
	counts = sysapprv.getAggregate('COUNT');
	gs.print('RITM: '+  sysapprv.sysapproval.getDisplayValue());
	gs.print('ITEM: '+ sysapprv.sysapproval.cat_item.getDisplayValue());
	gs.print('Approver: '+ sysapprv.approver.getDisplayValue());
}

View solution in original post

ronaldanand · ‎06-06-2019

Thank a lot mike 🙂

Wonderful , Now its working!!!!! 🙂

Thanks Much for your kind help and reply