Phone Contact Point

You might find some help starting on page 21 of this presentation from TLCC2015.

https://tlcc2015.tessituranetwork.com/meetings/281457

It talks about the new V12 Communication Management table structure.

Here is a code snippet from this presentation.

Purpose to Contact Point Purpose

§ Using mail_purpose (v11)

Select * from T_ADDRESS

Where customer_no = @customer_no

and mail_purposes like '%B%'

§ Using Contact Point Purposes (v12)

Select *

from T_ADDRESS a

join TX_CONTACT_POINT_PURPOSE cp on a.address_no = p.contact_point_id

Where customer_no = @customer_no

and cp.purpose_id = @purpose_board

--Tom

…

718.724.8135

tbrown@BAM.org

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jane Voytek
Sent: Monday, August 24, 2015 4:10 PM
To: Thomas Brown <tbrown@bam.org>
Subject: [Tessitura Development Forum] Phone Contact Point

We would like to use phone contact point in our extractions to weed out people with no active phone number, but are finding that constituents get selected as having a phone number contact point any time there is a phone number anywhere in their record, even if it is linked to an inactive address.

Are others having this problem, or has anyone found a work around?

I would also be interested in knowing if this has already been reported to Tessitura, and maybe a fix is in the works already?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

You might find some help starting on page 21 of this presentation from TLCC2015.

https://tlcc2015.tessituranetwork.com/meetings/281457

It talks about the new V12 Communication Management table structure.

Here is a code snippet from this presentation.

Purpose to Contact Point Purpose

§ Using mail_purpose (v11)

Select * from T_ADDRESS

Where customer_no = @customer_no

and mail_purposes like '%B%'

§ Using Contact Point Purposes (v12)

Select *

from T_ADDRESS a

join TX_CONTACT_POINT_PURPOSE cp on a.address_no = p.contact_point_id

Where customer_no = @customer_no

and cp.purpose_id = @purpose_board

--Tom

…

718.724.8135

tbrown@BAM.org

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jane Voytek
Sent: Monday, August 24, 2015 4:10 PM
To: Thomas Brown <tbrown@bam.org>
Subject: [Tessitura Development Forum] Phone Contact Point

We would like to use phone contact point in our extractions to weed out people with no active phone number, but are finding that constituents get selected as having a phone number contact point any time there is a phone number anywhere in their record, even if it is linked to an inactive address.

Are others having this problem, or has anyone found a work around?

I would also be interested in knowing if this has already been reported to Tessitura, and maybe a fix is in the works already?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!