question Re: Service Portal Widget: how to get sys_id ? in Developer forum

Service Portal Widget: how to get sys_id ?

stryker129 — Wed, 26 Apr 2017 16:40:08 GMT

Hi guys,

In my custom Customer table how can I get sys_id for each record?

var gr = new GlideRecord("x_11111_notes_customers");
gr.addActiveQuery();
gr.orderByDesc('sys_updated_on');
gr.query();
data.customers = [];
while(gr.next()){
       var customer = {};
       customer.id = gr.sys_id;
       customer.name = gr.getDisplayValue('name');
       data.customers.push(customer);
}

This code in line #10 returns nothing.

Where I am wrong?

Thanks

Re: Service Portal Widget: how to get sys_id ?

BALAJI40 — Wed, 26 Apr 2017 16:45:23 GMT

Use this one, $sp.getParameter("sys_id")

Can i know what you are doing above I did not understand.

Re: Service Portal Widget: how to get sys_id ?

stryker129 — Wed, 26 Apr 2017 16:53:37 GMT

There is no code above. This is the full Server Script in my widget. The requirement is to get all records with sys_id and name from Customers table and pass the data to Client.

Re: Service Portal Widget: how to get sys_id ?

Ujjawal Vishnoi — Wed, 26 Apr 2017 17:08:44 GMT

Hi Ivan,

Replace customer.id = gr.sys_id; with customer.id = gr.getValue('sys_id') or customer.id = gr.sys_id+'';

Hope this helps.

Regards,

Ujjawal

Re: Service Portal Widget: how to get sys_id ?

Freddie Pokrzy1 — Wed, 26 Apr 2017 18:18:53 GMT

Ivan,

When I have encountered this issue in the past what you need to do is either convert the sys_id to a string gr.sys_id.toString() or get the display value gr.getDisplayValue("sys_id") of the sys_id. I am not really sure why you need to do it this way but this is how I was able to resolve it when I ran into it,

Code Example:

data.customers = [];

var gr = new GlideRecord("x_11111_notes_customer");

gr.addActiveQuery(); gr.orderByDesc("sys_updated_on");

gr.query();

while(gr.next()){

customer = {};

customer.id = gr.getDisplayValue("sys_id");

customer.name = gr.getDisplayValue("name");

data.customers.push(customer);

}

Hope this helps..

Freddie

Re: Service Portal Widget: how to get sys_id ?

stryker129 — Wed, 26 Apr 2017 18:24:55 GMT

I need it for editing specific customer in custom Service Portal page form.

Re: Service Portal Widget: how to get sys_id ?

Ujjawal Vishnoi — Wed, 26 Apr 2017 18:30:15 GMT

Hi Ivan,

Have you tried to replace customer.id = gr.sys_id; with customer.id = gr.sys_id+'';

As per my understanding this should also work.

Regards

Ujjawal

Re: Service Portal Widget: how to get sys_id ?

stryker129 — Wed, 26 Apr 2017 18:34:28 GMT

Not yet. Will try tomorrow. sys_id +'' - LOL is it a bug in SN?

Re: Service Portal Widget: how to get sys_id ?

BALAJI40 — Wed, 26 Apr 2017 18:34:58 GMT

No on service portal gr.getDisplayValue("sys_id"), it only works.

customer.id = gr.sys_id+'' and customer.id = gr.getValue('sys_id') all are not working.

Re: Service Portal Widget: how to get sys_id ?

Ujjawal Vishnoi — Wed, 26 Apr 2017 18:38:17 GMT

It is same as toString().

In your previous scenario when you were using customer.id = gr.sys_id then in this case you were actually assigning an object to customer.id. However you were expecting the value of sys_id. That was the issue.

Hope this helps.

Regards

Ujjawal

Re: Service Portal Widget: how to get sys_id ?

stryker129 — Thu, 27 Apr 2017 12:25:45 GMT

Thanks. It works.