How to display the list of record one by one with required details?

[India_farheenk]

Scenario:  I am Gliding a table for example 'incident', after applying query there are should be 10 incidents displayed.

Expected output: All 10 record should be displayed one by one with required details.

Output: 

{

"Number": Incident1,
"Category": cat,
"State": state,
"Short Description": sd,
"Description": des

},

{

"Number": Incident2,
"Category": cat,
"State": state,
"Short Description": sd,
"Description": des

},

and so on

Please help @Ankur Bawiskar @Community Alums @Allen Andreas @BharathChintala 

Used script:

	var gr = new GlideRecord('incident');
	gr.addQuery('Active',true);
	gr.query();
	while(gr.next()){
		var num = gr.number;
		var cat = gr.category.getDisplayValue();
		var state = gr.state.getDisplayValue();
		var sd = gr.short_description.getDisplayValue();
		var des = gr.description.getDisplayValue();
		
	}

    return {
        "Number": num,
        "Category": cat,
        "State": state,
	"Short Description": sd,
	"Description": des

    };

[Allen Andreas · Accepted solution]

Hi,

You'd need to apply a query to your GlideRecord script to target specific records, as you mentioned in your post. You can navigate to list view of incidents, build your query, then right-click the last piece of the breadcrumb and use an additional line (right above your gr.query();) such as:

gr.addEncodedQuery("paste_here");

 As far as building an array of data, you could use:

var array = [];	

var gr = new GlideRecord('incident');
//gr.addEncodedQuery("paste_here");
gr.addQuery('active',true);
gr.setLimit(10);
gr.query();
while(gr.next()){
var obj = {
        "Number": gr.getValue('number'),
        "Category": gr.category.getDisplayValue(),
        "State": gr.state.getDisplayValue(),
	"Short Description": gr.short_description.getDisplayValue(),
	"Description": gr.description.getDisplayValue()
}
array.push(obj);
}
gs.info(JSON.stringify(array, null, 2));

[Ankur Bawiskar]

@India_farheenk 

Allen has shared the script.

Please try that and share feedback

[India_farheenk]

@Allen Andreas @Ankur Bawiskar 

We are getting response in one line, please find the below screenshot:

We are trying in REST API Explorer.

[vishalj · Accepted solution]

Hi @India_farheenk ,

Use below script. It will work.

var array = [];	

var gr = new GlideRecord('incident');
gr.addQuery('active',true);
gr.setLimit(10);
gr.query();
while(gr.next()){
var obj = {
        "Number": gr.getValue('number'),
        "Category": gr.category.getDisplayValue(),
        "State": gr.state.getDisplayValue(),
	"Short Description": gr.short_description.getDisplayValue(),
	"Description": gr.description.getDisplayValue()
};
array.push(obj);
}

var str =  JSON.stringify(array);
var array = JSON.parse(str);
return array;	

[Shamma Negi]

USe this.

var array = [];
var len;
var gr = new GlideRecord('incident');
//gr.addEncodedQuery("paste_here");
gr.addQuery('active',true);
gr.setLimit(10);
gr.query();
while(gr.next()){
var obj = {
"Number": gr.getValue('number'),
"Category": gr.category.getDisplayValue(),
"State": gr.state.getDisplayValue(),
"Short Description": gr.short_description.getDisplayValue(),
"Description": gr.description.getDisplayValue()
}
array.push(obj);
len = array.length;

}

gs.info(JSON.stringify(array));
gs.info(len);
var spaces = [];
for(var i=0;i<len;i++)
{
spaces += JSON.stringify(array[i]) + "\n";
}
gs.info(spaces);

Hope this helps!

Regards,

Shamma

[Allen Andreas]

Hello @India_farheenk 

All you need to do is add a few parms in the output, like so:

var array = [];	

var gr = new GlideRecord('incident');
//gr.addEncodedQuery("paste_here");
gr.addQuery('active',true);
gr.setLimit(10);
gr.query();
while(gr.next()){
var obj = {
        "Number": gr.getValue('number'),
        "Category": gr.category.getDisplayValue(),
        "State": gr.state.getDisplayValue(),
	"Short Description": gr.short_description.getDisplayValue(),
	"Description": gr.description.getDisplayValue()
}
array.push(obj);
}
gs.info(JSON.stringify(array, null, 2));

Which results in example: