How to get the sys_id of 100 records

[preethigovi]

Hi Team,

I need sys id of 100 records by passing short description. The short desc may contain ',(,& in it. How we can get sys id of this records,

eg: short description :

Discuss New Hire's Career Journey

[Medi C · Accepted solution]

@preethigovi,

Are you having a list of short descriptions that you need to look for the record sys_ids? If so, please try:

function getSysIds(shortDescriptions) {
	var result = [];
    var grIncident = new GlideRecord("incident"); //Replace with the table you want
    grIncident.addQuery("short_descriptionIN" + shortDescriptions);
    grIncident.query();

    while (grIncident.next()) {
        result.push(grIncident.sys_id);
    }
	return result;
}


//Usage: Example
var shortDescriptions = ["Discuss New Hire's Career Journey", "TEST SHort Description"];
var sysIds = getSysIds(shortDescriptions);
gs.info(sysIds);

//Results:
//Script: 690923053b6caed0e301de2a85e45a4b,690923053b6caed0e301de2a85e45a4b

[Rohit Singh · Accepted solution]

Hi @preethigovi ,

You can write a script.

var sysid = [];
var gr = new GlideRecord("table_name");
gr.addQuery("short_descriptionLIKE
Discuss New Hire's Career Journey");
gr.setLimit(100);  // Limiting 100 record to get the sys_id.
gr.query();
while(gr.next())
{
  sysid.push(gr.sys_id);

}

gs.print(sysid);

For optimum result you can go to the table list view and build the query using filter and copy the filter. Use the copied filter in line gr.addQuery("paste_copied_filter_query")

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Rohit

[Ankur Bawiskar · Accepted solution]

@preethigovi 

since you only want 100 records, please use setLimit()

var shortDescription = "Discuss New Hire's Career Journey";
var gr = new GlideRecord('incident');
gr.addQuery('short_description', 'LIKE', shortDescription);
gr.setLimit(100);
gr.query();
var sysIds = [];
while (gr.next()) {
    sysIds.push(gr.getValue('sys_id'));
}
gs.info('Sys IDs: ' + sysIds.join(', '));

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Medi C · Accepted solution]

@preethigovi,

Are you having a list of short descriptions that you need to look for the record sys_ids? If so, please try:

function getSysIds(shortDescriptions) {
	var result = [];
    var grIncident = new GlideRecord("incident"); //Replace with the table you want
    grIncident.addQuery("short_descriptionIN" + shortDescriptions);
    grIncident.query();

    while (grIncident.next()) {
        result.push(grIncident.sys_id);
    }
	return result;
}


//Usage: Example
var shortDescriptions = ["Discuss New Hire's Career Journey", "TEST SHort Description"];
var sysIds = getSysIds(shortDescriptions);
gs.info(sysIds);

//Results:
//Script: 690923053b6caed0e301de2a85e45a4b,690923053b6caed0e301de2a85e45a4b

[Medi C]

Hello @preethigovi,

Thank you for marking my response as helpful, if that helped resolved your query, please accept the solution and close the thread, so that it benefits future readers. 

[Medi C]

Hello @preethigovi,

I hope you are doing well! Was this helpful? If so, kindly accept the solution and close the thread so that it benefits future readers. 

[Rohit Singh · Accepted solution]

Hi @preethigovi ,

You can write a script.

var sysid = [];
var gr = new GlideRecord("table_name");
gr.addQuery("short_descriptionLIKE
Discuss New Hire's Career Journey");
gr.setLimit(100);  // Limiting 100 record to get the sys_id.
gr.query();
while(gr.next())
{
  sysid.push(gr.sys_id);

}

gs.print(sysid);

For optimum result you can go to the table list view and build the query using filter and copy the filter. Use the copied filter in line gr.addQuery("paste_copied_filter_query")

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Rohit