Service Portal Widget: how to get sys_id ?

[stryker129]

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

[BALAJI40]

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

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

[stryker129]

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.

[Ujjawal Vishnoi]

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

[Ujjawal Vishnoi]

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