How do I configure a custom ticket field to show a value for a phone number?
SELECT HD_TICKET.ID, CUSTOM_FIELD_VALUE1 as PHONENUMBER,OWNER.EMAIL as OWNEREMAILFROM HD_TICKET JOIN USER OWNER on OWNER.ID = HD_TICKET.OWNER_IDWHERE CUSTOM_FIELD_VALUE1
Depending on what all you pull from Active Directory you could use a query such as:
query: select distinct(WORK_PHONE) from USER
If the field was set to Single Select, it would list all the numbers and allow you select it from the drop down after typing the last 4 digits.
I don't have much experience with them, but I suppose a rule could be created to force the set 7-10 character length if desired instead.