• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 52 views
  • Users 0 members are here
Related

Table that shows an address is inherited

Former Member
Former Member $organization

Is there a table that indicates if an address (or phone) is inherited?

Parents
  • Former Member
    Former Member $organization

    Thanks Levi. That’s a good idea.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Wednesday, March 13, 2013 3:45 PM
    To: Gloria Ormsby
    Subject: Re: [Tessitura Technical Forum] Table that shows an address is inherited

     

    Gloria,

    I don't think there is a table that spells this out explicitly.  But you could extrapolate something into a view. By looking for customer numbers in T_ADDRESS that don't have any addresses marked as primary.

    The other place I would suggest looking for a bit of head start on it is the Table-valued Function FT_GET_PRIMARY_ADDRESS.  It handles returning a primary address for any constituent, even if it is inherited. 

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 3/13/2013 2:29:49 PM

    Is there a table that indicates if an address (or phone) is inherited?




    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!

Reply
  • Former Member
    Former Member $organization

    Thanks Levi. That’s a good idea.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Wednesday, March 13, 2013 3:45 PM
    To: Gloria Ormsby
    Subject: Re: [Tessitura Technical Forum] Table that shows an address is inherited

     

    Gloria,

    I don't think there is a table that spells this out explicitly.  But you could extrapolate something into a view. By looking for customer numbers in T_ADDRESS that don't have any addresses marked as primary.

    The other place I would suggest looking for a bit of head start on it is the Table-valued Function FT_GET_PRIMARY_ADDRESS.  It handles returning a primary address for any constituent, even if it is inherited. 

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 3/13/2013 2:29:49 PM

    Is there a table that indicates if an address (or phone) is inherited?




    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!

Children
No Data