• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 45 views
  • Users 0 members are here
Related

Query to get email address out with a contact purpose

Joseph Shafranek
$organization

Hi All;

I'm working on a report for my  development dept. and I need to get an email address out of the system with a specific contact purpose we have entering in to their record. I haven't  figured out where the contact purpose is tied to the email address to pull the information out of the database.

I'm sure others have run into this problem and I'm wondering how they handle it.

Any advice would be much appreciated.

Joe Shafranek

jshafranek@westportplayhouse.org

  • $organization

    Hi Joe,

    A purpose is tied to the eaddress_no in TX_CONTACT_POINT_PURPOSE where it is called contact_point_id.

    Cheers,

    Kevin

  • Former Member
    Former Member $organization

    Hi Joe,

     

    In T_EADDRESS there is a column called mail_purposes. Be sure to use “has” as the field is a string of id numbers and so can have more than one id if there is more than 1 purpose the address is used for.

     

    Gloria

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Joseph Shafranek
    Sent: Friday, August 21, 2015 4:24 PM
    To: Gloria Ormsby
    Subject: [Tessitura Technical Forum] Query to get email address out with a contact purpose

     

    Hi All;

    I'm working on a report for my  development dept. and I need to get an email address out of the system with a specific contact purpose we have entering in to their record. I haven't  figured out where the contact purpose is tied to the email address to pull the information out of the database.

    I'm sure others have run into this problem and I'm wondering how they handle it.

    Any advice would be much appreciated.

    Joe Shafranek

    jshafranek@westportplayhouse.org




    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 Former Member

    Normal 0 false false false EN-US X-NONE X-NONE

    Hi Kevin & Gloria;

    Kevin that was just what I was looking for. I created a local view join T_EADDRESS and TX_CONTACT_POINT_PURPOSE and filter the PURPOSE_ID to the id I’m using, I got just what I needed.

    Gloria in checking the T_EADDRESS table the mail purpose field are not the same as new contact purposes as most of those fields had null values. But joining both tables work perfectly.

    Thank you both for your help.

  • $organization in reply to Joseph Shafranek

    Hi Joseph,

    Would you be willing to share your local view with me please?

    I'm on d.hall@festival.melbourne if you wouldn't mind sending it over.

    Thanks so much!

    dgh