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.
Yes, I discovered that pretty early on. I'm trying to add an element group, but not sure about the "Data from" field.
Ok, so you need to know SQL for this?
It's definitely helpful but a lot of people use the Cookbook Tom mentioned to create what they need without really knowing any SQL. If you want to email me, I have made a lot (too many) of output elements for my various groups and I'd be happy to send you any help I can? mwaltz@kalamazooarts.org
Here is a link to a video that will give you a bit more of a step by step approach to the topic.
https://www.tessituranetwork.com/Items/Videos/Training/Extending_Output_Sets
I really appreciate that! Let me review the video Tom shared and give it another shot tomorrow. If I fail, I’ll email you.
Thank you!!