We've discovered an issue when pulling phone numbers in our output sets.
If we select the criteria "Phone 1" and "Phone 2" we aren't receiving that information. In the "Phone 1" column we are receiving the "Business" number and in the "Phone 2" column we are receiving the "Phone 1" information.
I'm wondering if anyone knows where I can fix this? Or should I open a support ticket?
Thanks!
You can change it by editing LP_GET_PHONES to specify that. By default what you're really getting there is "Day phone" and "Eve Phone", hence business and phone1. It's not actually grabbing them based on type. It's confusing since the query elements say "1" and "2".
Perfect! Thanks
This is probably a long shot, but I did find the below and since I'm an end user who doesn't know SQL, I am not sure how to do this. Where do you access LP_GET_PHONES?
Because Phone Type descriptions may be user defined, titles such as Phone1 and Phone2 found in Output Sets, Extractions and Reports do not refer directly to phone types with the same description. Instead, these titles simply refer to the first and second phone numbers returned by the procedure AP_GET_PHONES. By default, this procedure returns Day Phone (type 7, business), Evening Phone (type 1, phone 1), and Fax Phone (type 3, fax).
AP_GET_PHONES first calls a localized procedure called LP_GET_PHONES to utilize any custom code for retrieving numbers. It is possible to customize this local procedure to define which two phone types are returned as Phone1 and Phone2 in output sets, extractions and reports.
NOTE: The impresario and impresario_cci databases both contain the procedure LP_GET_PHONES. Modifying LP_GET_PHONES in the impresario database changes how phone numbers are returned in reports. Modifying LP_GET_PHONES in the impresario_cci database modifies how phone numbers are returned in extractions.
NOTE: The impresario_cci database is deprecated in v15. The impresario_cci tables and procedures migrate to the impresario database as part of the v15 upgrade.
Archived Number: 16103
LP_GET_PHONES is a stored procedure that you would access through SQL Server Management Studio. What may be easier than that if you don't have anyone at your organization who is an experience SQL user is adding new query elements that look at T_PHONE and can pull any of the phone types you may want.
Brian - I'd be interested. Let me know if you don't have my email. Thanks!
Hello Jennifer,
As you are a RAMP user, you can just open up a help ticket and let us know which phone types you'd like LP_GET_PHONES to return in Phone1/Phone2 in your output sets. You can find the ID values in the TR_PHONE_TYPE system table. We'll be happy to make that edit for you.
Regards,
Brian
Thanks Brian!
you bet
Brian - I am not sure how I missed this but I came back to search for answers on this same topic and found this post, again. Are you still able to help with this?