• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 109 views
  • Users 0 members are here
Related

Penultimate Membership Record in Output Set

Clint Dawley
$organization

Hi all!

Our membership director would like to see the last membership in the output set before the current one to determine lapsed time between renewals.  Is there any easy way to export this information in the output set?  Would it require creating a special view on the sql side?  Any suggestions that you might have would be greatly appreciated.  Have a wonderful day!

Clint Dawley

Parents
  • $organization
    I would likely use a view.

    But, you might be able to do something like a new query element that both filtered to only expired memberships, and then took the maximum expiration date of what was left in the set for each customer.

    Something like 

    select customer_no, max(expr_dt) from tx_cust_membership where status in (list of statuses you consider expired) group by customer_no 

    I’m not sitting in front of Tessitura right now, so I can’t give you the exact syntax fully worked out.

    Hope that is a bit of help.
    On Wed, Nov 29, 2017 at 2:06 PM, Clint Dawley <bounce-clintdawley6615@tessituranetwork.com> wrote:
    Update from Tessitura Network
    		Clint Dawley

    Hi all!

    Our membership director would like to see the last membership in the output set before the current one to determine lapsed time between renewals.  Is there any easy way to export this information in the output set?  Would it require creating a special view on the sql side?  Any suggestions that you might have would be greatly appreciated.  Have a wonderful day!

    Clint Dawley

    View online
     

    You received this notification because you subscribed to the forum.  To stop receiving updates from only this thread, go here.

    Flag this post as spam/abuse.
Reply
  • $organization
    I would likely use a view.

    But, you might be able to do something like a new query element that both filtered to only expired memberships, and then took the maximum expiration date of what was left in the set for each customer.

    Something like 

    select customer_no, max(expr_dt) from tx_cust_membership where status in (list of statuses you consider expired) group by customer_no 

    I’m not sitting in front of Tessitura right now, so I can’t give you the exact syntax fully worked out.

    Hope that is a bit of help.
    On Wed, Nov 29, 2017 at 2:06 PM, Clint Dawley <bounce-clintdawley6615@tessituranetwork.com> wrote:
    Update from Tessitura Network
    		Clint Dawley

    Hi all!

    Our membership director would like to see the last membership in the output set before the current one to determine lapsed time between renewals.  Is there any easy way to export this information in the output set?  Would it require creating a special view on the sql side?  Any suggestions that you might have would be greatly appreciated.  Have a wonderful day!

    Clint Dawley

    View online
     

    You received this notification because you subscribed to the forum.  To stop receiving updates from only this thread, go here.

    Flag this post as spam/abuse.
Children
No Data