phone_number_e164 not validating correctly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2023 08:07 AM - edited 08-07-2023 08:15 AM
The messaging phone (mobile_phone) field on sys_user table is not validating properly.
For Example: If mobile number is less than or equal to10 digits and not a valid phone number, it is not showing in invalid phone number list.
Example Mobile Number:
Country : United States Number: +845216xxxx
Country: India Number: +988612xxxx
var gr = new GlideRecord('sys_user');
gr.addActiveQuery();
gr.addNotNullQuery('mobile_phone');
gr.query();
var count = 0;
while (gr.next()) {
var phone = gr.mobile_phone.toString();
var gePN = new GlideElementPhoneNumber();
var valid = (phone.length > 0 && gePN.setPhoneNumber(phone, true));
if (!valid) {
++count;
gs.log(gr.user_name);
}
}
gs.log('Total: ' + count);