when I'm trying to get expiration dates and membership levels for the last membership of a list of constituents if they are...why do some come up blank and how can I get it to populate? It looks like it only populates something if the constituent is active or lapsed, not inactive
Hi folks! You can build a query element group based on VS_ELEMENTS_MEMBERSHIP_MOST_RECENT, which is a view added in Version 14 that pulls the farthest out membership for a constituent, with separate rows for each membership org. This will be an inactive membership if they never renewed, or a pending membership if they have renewed early, or a current membership if they are current and haven't renewed yet. If you include a single membership organization in the Data_Where column, or if you only have one organization, you can check the Single Row checkbox for each element. In that view, the expiration date column is expr_dt, just like in the regular membership data.
So for a system with one membership organization:
I hope that gets you started!
-Michael Flaherty-Wilcox, Tessitura Network
Thank you, Michael. Can you tell me this...
Is there a way to use this to output level and recognized amount as well?
Definitely. Here are the Entries for TR_QUERY_ELEMENT:
Level:
Recognition Amount:
YOU JUST MADE MY YEAR!!!!!! I can't thank you enough!
wait, one more thing. how about being able to output the membership campaign???
Of course :-)
Where have you been all my life? Or the past 3 months since I've been working in Tess...