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, Leah,
I'm having the same problem. My workaround has been to create a new Query Element Group for "Latest Membership" and select output elements from THAT group, instead. That way, if there's no current membership, you can still have output values.
Hi! I'm stumbled on this and desperately need to know how to do this. I'm new to Tess, where can I create a query element group? Off to search now, but in case you get this in the meantime, thank you!
Query Element Groups can be created in System Tables.
You may find the Query Element Cookbook to be very helpful. You need to get the right version of this document. Assuming you are on Tessitura version 14.1 or later try this.
https://www.tessituranetwork.com/en/Files/Docs/Customizations/Output-Set-Manager-Cookbook
Hi, Jennifer,
TR_QUERY_ELEMENT_GROUP is where you put entries to build a collection of data you can then use in output elements (constructed in TR_QUERY_ELEMENT)
The standard Tessitura membership output elements are pulled from a virtual table of *only current memberships* (I think) and therefore, you can't get anything to populate your output if the person doesn't have a current membership.
Thank you, will check this out!