Creating a query element to format phone numbers.

Actually you can call functions from an output set element.

However in this case as you would need to join to a few tables/views to get the information. Creating a view (that includes phone type) as Levi suggests is a good way to keep the element simple.

The output set element could then have a parameter of phone type so you can limit what is returned.

Things to remember – this will have the potential of returning more than one row of data as it is not a standard element for phones.

If your output set only returns one row per constituent you could always output it through extractions. Make your list the criteria for the segment and check the option where phones and postal codes are formatted.

Just a thought

Sandra

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
Sent: Wednesday, 20 February 2013 9:37 AM
To: Sandra Ashby
Subject: Re: [Tessitura Technical Forum] Creating a query element to format phone numbers.

I suspect you can't call database functions from an Output Set Element.  But you could create a view (called something like LVS_FORMATTED_PHONE) that uses AF_FORMAT_STRING so that the database returns a formatted phone number to the output set.

Is there a way to create a query element that will format the phone number with parenthesis and dashes?  I know this can be done in Excel but is there anyway to export with the format?

Thanks,

Elizabeth Carlock

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!