How to pass a table's field values from server to client via widget in Service Portal - Support and Troubleshooting

How to pass a table's field values from server to client via widget in Service Portal Issue Widgets are one of the necessities in Service Portal. They can be used in various cases. One of them can be related on how to pass a table's field values from server to client via the widget in Service Portal.

Resolution - The "data" is the object that binds Server Script and Client Controller in widget.

- We can use this object to add more variables/properties to pass data.

- Let's say we want to display an existing user's First Name and "Last Name" from "sys_user" table in the console (or alert box) via a widget.

- Create a new widget and add the following:

Body HTML template:

> Just Do It!

Server script:

(function() { /* populate the 'data' object */ /* e.g., data.table = $sp.getValue('table'); */ var userRecord = new GlideRecord('sys_user'); userRecord.addQuery('sys_id', 'sys_id_of_a_user'); //Add any other condition - This is a sample userRecord.query();

var user = {}; //User's record object containing values

if(userRecord.next() && input && input.action){ data.user = user; if(input.action == 'show'){ data.user.first_name = userRecord.first_name.toString(); data.user.last_name = userRecord.last_name.toString(); } } })();

Client Controller:

function() { /* widget controller */ var c = this; c.server.update(); //overwrites the data object with new updated contents console.log("User's first Name: " + c.user.first_name); console.log("User's first Name: " + c.user.first_name); }

Add this widget to a page and open that page in Service Portal. When you click this widget (that's loaded), you can check the console on desired data populating.

Furthermore, widgets can't access catalog variables on the Service Portal page. So manipulating the page won't be possible.

Related Links Please refer to the documentation on Service Portal Widgets: https://docs.servicenow.com/csh?topicname=c_Widgets.html&version=latest