question UI Macro to show Active Incidents and requests in Developer forum

UI Macro to show Active Incidents and requests

josephd01 — Fri, 09 Feb 2018 14:44:53 GMT

Hi,

I would like to create a UI Macro that will display active incidents and requests for the caller. I was able to find the below on the ServiceNow website, but this only displays the Active Incidents for the user.

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<g:evaluate var="jvar_guid" expression="gs.generateGUID(this);" />

<j:set var="jvar_n" value="show_incidents_${jvar_guid}:${ref}"/>

<g:reference_decoration id="${jvar_n}" field="${ref}"

onclick="showRelatedList('${ref}'); "

title="${gs.getMessage('Show related incidents')}" image="images/icons/tasks.gifx"/>

// show related list

function showRelatedList(reference) {

try {

var displayValue = g_form.getDisplayBox(reference).value;

var title = 'Showing records related to: ' + displayValue;

var query = 'caller_id' + '=' + g_form.getValue(reference);

query += '^' + 'active=true';

var gdw = new GlideModal('show_list');

gdw.setTitle(title);

gdw.setSize(750);

gdw.setPreference('table', 'incident_list');

gdw.setPreference('sysparm_query', query);

gdw.setPreference('title', 'A New Title');

gdw.render();

} catch (e) {

jslog('error showing related list');

jslog(e);

}

</script>

</j:jelly>

Thanking you in advance

Re: UI Macro to show Active Incidents and requests

Jaspal Singh — Fri, 09 Feb 2018 15:36:50 GMT

Hi Joseph,

You can try below snippet by creating a new UI Macro: show_related_requests

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<g:evaluate var="jvar_guid" expression="gs.generateGUID(this);" />

<j:set var="jvar_n" value="show_requests_${jvar_guid}:${ref}"/>

<g:reference_decoration id="${jvar_n}" field="${ref}"

onclick="showRelatedList('${ref}'); "

title="${gs.getMessage('Show related requests')}" image="images/icons/tasks.gifx"/>

// show related list

function showRelatedList(reference) {

try {

var displayValue = g_form.getDisplayBox(reference).value;

var title = 'Showing records related to: ' + displayValue;

var query = 'requested_for' + '=' + g_form.getValue(reference);

query += '^' + 'active=true';

var gdw = new GlideModal('show_list');

gdw.setTitle(title);

gdw.setSize(750);

gdw.setPreference('table', 'sc_request_list');

gdw.setPreference('sysparm_query', query);

gdw.setPreference('title', 'A New Title');

gdw.render();

} catch (e) {

jslog('error showing related list');

jslog(e);

}

</script>

</j:jelly>

Once done go to Requested For field on the Request form & do configure dictionary & add below attribute

Re: UI Macro to show Active Incidents and requests

josephd01 — Mon, 12 Feb 2018 13:45:11 GMT

Thank you this works., but now I have run into another issue. I want the incident and request Macro to be next to the callers name on the form, but I can only have one or the other. When I try to call both in the dictionary field it only displays the last macro called. Is there a way to display both on the same form? I am adding this to the call module as we need to know what the user has logged.

Re: UI Macro to show Active Incidents and requests

Jaspal Singh — Mon, 12 Feb 2018 14:40:29 GMT

Hi Joseph,

Then you need make changes in UI Macros & then use both incident & requested item table in a single macro.

Re: UI Macro to show Active Incidents and requests

Sarah Deady — Mon, 19 Feb 2018 16:53:26 GMT

I am also trying to show both related incidents and requests using the same UI Macro, but can only get one or the other to display, and not both at the same time. How can I reference both tables in the same Macro and have them both display?

Re: UI Macro to show Active Incidents and requests

Sarah Deady — Fri, 23 Feb 2018 17:43:57 GMT

I'm also trying to show both requests and incidents for callers using the same UI Macro, but I cannot get them both to display, only one or the other. I can't figure out how to adjust the script to reference both tables in the same Macro. I'm currently using the following to display incidents; how can I fix this to show both?

function showRelatedLists(reference) {
	try {
		var displayValue = g_form.getDisplayBox(reference).value;
		var title = 'Showing records related to: ' + displayValue;
		var s = reference.split('.');
		var referenceField = s[s.length - 1];
		if (referenceField == 'caller') {
			referenceField = 'caller_id';
		}
		var query = referenceField + '=' + g_form.getValue(reference);
					
		var gdw = new GlideModal('show_list');
		gdw.setTitle(title);
		gdw.setSize(750);
		gdw.setPreference('table', 'incident_list');
		gdw.setPreference('sysparm_query', query);
		gdw.setPreference('title', 'A New Title');
		gdw.render();
	} catch (e) {
		jslog('error showing related list');
		jslog(e);
	}
}

Re: UI Macro to show Active Incidents and requests

ayman_h — Tue, 12 Feb 2019 14:23:10 GMT

To display both ACTIVE Incidents and Requests for a user on a popup, use this code below

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<g:evaluate var="jvar_guid" expression="gs.generateGUID(this);" />
<j:set var="jvar_n" value="show_calls_${jvar_guid}:${ref}"/>
<g:reference_decoration id="${jvar_n}" field="${ref}"
onclick="showRelatedList('${ref}'); "
title="${gs.getMessage('Show related calls')}" image="images/icons/tasks.gifx" icon="icon-tree-right"/>

</script>
</j:jelly>

Re: UI Macro to show Active Incidents and requests

Ganesh90 — Mon, 11 Apr 2022 10:09:26 GMT

in san diego they add a new function function decorationshow.

what this function is doing?