• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 20 views
  • Users 0 members are here
Related

Trying to pull a fax number on an output set

Matthew Hodge
$organization

Hi,

Our Education team is trying to pull out a list of fax numbers for all the schools on our databases using an output set. The only problem is that every school has two addresses - a postal address (the primary one) and a physical address (non-primary). The fax number is located on the physical address.

So when we run the output set using the Fax element, it only looks for a fax number tied to the primary address. How do I get an output set to pull that info from a non-primary address?

 

Cheers,

 

Matt

Parents
  • $organization

    Hi Matt

    Another option is to create an Output Set element specific to the address type.

     

    So in T_QUERY_ELEMENT

    Description:        “Fax – PO Box” (or whatever describes the associated address type)

    Category:            Address Information

    Data:                     !.phone

    Data From:          (select p.*, a.address_type  from vs_phone p join vs_address a on p.address_no = a.address_no)

    Data Where:       type = 3 and address_type = 13                (assumes Fax is phone type 3 and replace the address_type 13 with the ID of your specific type)

     

    Regards

    Peter

     

    + Peter Nelson

    + Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
    Sent: Wednesday, 22 August 2012 09:56
    To: Peter Nelson
    Subject: RE: [Tessitura Technical Forum] Trying to pull a fax number on an output set

     

    I could definitely set that up, but surely if Tessitura can handle several address types on the one record, there must be a way of pulling that data out? I'll keep hunting.

    From: Kathleen Smith <bounce-kathleensmith6726@tessituranetwork.com>
    Sent: 8/21/2012 1:57:57 AM

    Hi Matt,

     

    I haven’t played with this in a while, but maybe try setting up a query element parameter for the fax criteria, that lets you choose between address types?...

     

    Cheers,

    Kathleen                                                                              

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
    Sent: Tuesday, 21 August 2012 4:33 PM
    To: Kathleen Smith
    Subject: [Tessitura Technical Forum] Trying to pull a fax number on an output set

     

    Hi,

    Our Education team is trying to pull out a list of fax numbers for all the schools on our databases using an output set. The only problem is that every school has two addresses - a postal address (the primary one) and a physical address (non-primary). The fax number is located on the physical address.

    So when we run the output set using the Fax element, it only looks for a fax number tied to the primary address. How do I get an output set to pull that info from a non-primary address?

     

    Cheers,

     

    Matt




    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!

    Click here to report this email as spam.




    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!

  • $organization in reply to Peter Nelson

    I ended up doing something like that. It's also made me realise that I need to look further into Mailing Purpose, because this seems to be the key that specifies which address comes out. Thanks, everyone!

Reply Children
No Data