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

[ronaldanand]

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]

try

var sysapprv = new GlideRecord('sysapproval_approver');
sysapprv.addQuery('state', 'requested');
sysapprv.addQuery('sysapproval.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());
	}    
}

[Mike Patel]

or try

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

[ronaldanand]

Hi Mike

I got below result nad RITM & CAT ITEM not  display

*** Script: andrewww---->66
*** Script: RITMundefined
*** Script: ITEMundefined
*** Script: Approver ******
*** Script: RITMundefined
*** Script: ITEMundefined
*** Script: Approver*****
*** Script: RITMundefined
*** Script: ITEMundefined
*** Script: Approver*****
*** Script: RITMundefined
*** Script: ITEMundefined
*** Script: Approver *****
*** Script: RITMundefined
*** Script: ITEMundefined
*** Script: Approver*****

Both Script not display RITM & CAT ITEM

Pls help me to fix this

[Brian Lancaster]

This line of code:

sysapprv.addQuery('sysapproval.table', 'sc_req_item');

should be:

sysapprv.addQuery('source_table', 'sc_req_item');

there is not field by the name of table on the sysapproval_approver table.