question Get fields and their values from another table in SP widget? in Developer forum

Get fields and their values from another table in SP widget?

robhaas — Tue, 11 Apr 2017 16:16:55 GMT

I am working with the Ticket Fields widget in Service Portal. When I look at the code, I see

var fields = $sp.getFields(gr, 'fieldnameshere');

From what I can tell, this is simply getting specified field names from the current record. Then in the html body, we run a ng-repeat="field in data.fields" and print the label and value of each field. I like the layout of this widget and have cloned it. However, I have the current table set to the sysapproval_approver table. I would like the fields to be selected from the corresponding task that needs approval.

So basically, the server script sets gr to the current record. I set inc to the sysapproval record. From this point, I want to say fields = specific fields from the incident table, not the sysapproval table.

var gr = $sp.getRecord();

var inc= gr.sysapproval;

All help is much appreciated.

Re: Get fields and their values from another table in SP widget?

ChrisBurks — Wed, 12 Apr 2017 01:12:34 GMT

When using $sp.getRecord() with no parameters given the method will return the GlideRecord of the current "widget instance". To get a GlideRecord of a specific table then you must pass the parameters (table, sys_id) or (table, GlideElement).

So something like so should work:

var gr = $sp.getRecord('incident', '9c573169c611228700193229fff72400') // substitute table and sys_id with desired data

var inc_short_desc = gr.short_description; // substitute with the desired fields

Re: Get fields and their values from another table in SP widget?

robhaas — Wed, 12 Apr 2017 10:37:53 GMT

For some reason this didn't post as a question. However, I marked your response as helpful and liked it as it was exactly what I needed. Appreciate it!

Re: Get fields and their values from another table in SP widget?

dvp — Wed, 12 Apr 2017 12:36:50 GMT

Thought this might be helpful

Portal diaries: Service Portal — Approval Summarizer in Portal

Re: Get fields and their values from another table in SP widget?

ChrisBurks — Thu, 13 Apr 2017 02:41:16 GMT

No worries. Glad I could help.