Glide record location table and print all locations whose latitude are not empty and greater than 50

Helan · ‎05-23-2025

J Siva · ‎05-24-2025

Hi @Helan
Try the below script.

var locationGr = new GlideRecord('cmn_location');
locationGr.addNotNullQuery('latitude');
locationGr.addQuery('latitude', '>', 50);
locationGr.query();
while (locationGr.next()) {
  gs.info(locationGr.getValue('name'));
}

Regards,
Siva

View solution in original post

SumanthDosapati · ‎05-24-2025

@Helan

Below script should work :

var loc = new GlideRecord("cmn_location");
loc.addEncodedQuery("latitude>50");
loc.query();
while (loc.next()){
    gs.info(loc.getDisplayValue());
}

Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth