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
UPDATE after working in Google hangouts with Jennifer Vinson yesterday:
I am a lying liar who cannot get output sets in v15.1.4 to actually output rows for any membership that is expired/not current. The code works if I just run it as various select statements in SSMS but when I put it into the TR_QUERY_ELEMENT_GROUP table and then create elements from the group/groups, most of them are just empty in the output. I should add that if I only create one element from the group, its's fine. But trying to have more than one not only creates multiple rows in the output, it outputs bad data.
Which leads me to my follow-up question:
**Does anyone know if there is something in the way the SQL code is "put together" from the table entries that would prevent the results from displaying appropriately? I feel like somehow/some way, it's getting caught up in the virtual "Membership" information (that only pulls current membership data) even though I am using VXS_CUST_MEMBERSHIP in my "Data From" field and not ANYthing virutal, so I cannot figure it out. Before I open a question ticket with RAMP (who are super busy helping people with refunds right now, I suspect) I wanted to put it out there to you all - any idea why this might not work?
UPDATE from Jen: Mindee is still awesome!!!