Get sys id by display value

[hatazhix]

Hello,

I am making Business Rule that checks incident number and gets it's sys id.

Problem is how can i make a script that checks my display value for example "INCE0012345" as a query?

	var inc = new GlideRecord('incident'); query that queries the display value and return sys id of this ince0012345
	inc.addQuery("sys_id", 'this is ince0012345 sys id');
	inc.query();

[hatazhix]

hi,

i want to grab sys id of the record that I know number like this:

var gr = new GlideRecord('incident');  

gr.addQuery('number', 'INCE0014635');  

gr.query();  

gs.print(gr.getRowCount());

gs.print(gr.sys_id);

it displays that Row count was 1 and sys_id was empty. Cant figure out whats the problem.

[sergiu_panaite · Accepted solution]

To display the sys_id you need to do:

var gr = new GlideRecord('incident');

gr.addQuery('number', 'INCE0014635');

gr.query();

while(gr.next()){

gs.print(gr.sys_id);

}

Regards,

Sergiu

[hatazhix]

thank you very much! I got it working.

[sergiu_panaite]

Glad I could help.

[pratulagarwal]

You are missing while(gr.next());