How to glide record location table and print all locations whose latitude are not empty and greater

[Helan]

How to glide record location table and print all locations whose latitude are not empty and greater than 50 

[SAI VENKATESH · Accepted solution]

Hi @Helan 

You can use the below script:

var locvalue=new GlideRecord('cmn_location');
locvalue.addEncodedQuery('latitudeISNOTEMPTY^latitude>50');
locvalue.query();
while(locvalue.next()){
	gs.print("Locations are"+locvalue.name);
}

You can try it in background script and you can change it based upon your need

Thanks and Regards

Sai Venkatesh

[Helan]

Thank you, @SAI VENKATESH @! This worked for me

[SAI VENKATESH]

Hi @Helan 

can you mark the solution as correct so that it can be helpful for others.

Thanks and Regards 

Sai venkatesh