Glide list data type

[Kasi Ramanathan]

 I need to print the latitude and longitude of list type reference field. Kindly help on the script.

var list =  gr.u_impacted_locations.toString();
var array = list.split(",");
for (var i=0; i < array.length; i++) {
var location = array[i];
gs.log(location.longitude);
gs.log(location.latitude);
//gs.log("Display value is: " + array[i]);
}

[Anil Lande · Accepted solution]

Hi,

As u_impacted_locations is Glide List (List field), you only get sys_id's of selected records there.

you need to Glide to get record details.

update your script like:

var list =  gr.u_impacted_locations.toString();
var array = list.split(",");
for (var i=0; i < array.length; i++) {
var location = new GlideRecord('cmn_location');
location.get(array[i].toString());

gs.log(location.longitude);
gs.log(location.latitude);
//gs.log("Display value is: " + array[i]);
}

Thanks,

Anil Lande

[Ankur Bawiskar]

Hi,

Please provide details on on which table that glide list field is present? to which table it refers

you can directly print the display value like this

var list =  gr.u_impacted_locations.getDisplayValue();

Also assuming your list field refers to cmn_location table you need to iterate over all the sys_ids

var list =  gr.u_impacted_locations.toString();

var array = list.split(",");

for (var i=0; i < array.length; i++) {

	var gr = new GlideRecord("cmn_location");
	if(gr.get(array[i])){
		gs.info(gr.longitude);
		gs.info(gr.latitude);
	}
}

Regards
Ankur