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

[J Siva · Accepted solution]

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

[Helan]

Thank you @J Siva ! This worked

[J Siva]

@Helan Glad it helped 

[Helan]

Thank you! This worked