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
This overall thread was so helpful! Big thanks to Michael Flaherty-Wilcox for all the responses.Just adding my two cents of what I just pulled together to get what I needed (most recent membership details including amount, etc..., for all primary affiliates in the household). Just in case it is ever helpful for someone else who comes across this thread. We already had a custom view built for membership because we need the French version of some of the fields...so came up with this and as far as I can tell, it is working great:(SELECT b.expanded_customer_no AS "customer_no", a.row_num, a.expr_dt, a.memb_level_desc, a.memb_amt, a.memb_level_desc_en, a.memb_level_desc_fr, a.recog_amt, a.memb_org_no FROM LVS_RECENT_MEMB a LEFT JOIN VS_CUSTOMER_WITH_PRIMARY_AFFILIATES b ON a.customer_no = b.customer_no)
Did the same thing in query element, data select for !.memb_amt, !.memb_level_desc, etc...
I thought I had it all figured out, but alas, one last question that I am hoping someone on this thread might have some ideas about...Our membership manager is also looking to be able to pull the HOUSEHOLD salutation even when sending to a different individual on the membership. For something like a grid with all the membership details or a something like "For your renewal please contact the primary members ____salutation_____" type idea.Is there a way to do this? Because the salutations are stored in a virtual table, I am unsure exactly how to do this..
Okay, trial and error, I think I have it. But if someone sees this and wants to double check, I would really appreciate it...
TR_QUERY_ELEMENT_GROUP
Data From: (SELECT b.expanded_customer_no AS "customer_no", a.lsal_desc, a.esal1_desc, a.esal2_desc FROM VXS_CUST_SAL a LEFT JOIN VS_CUSTOMER_WITH_PRIMARY_AFFILIATES b ON a.customer_no = b.customer_no)