Hi all,
I'm having some trouble with some dynamic lists not "dynamic-ing" as they ought to. Some of them work, but some do not: I seem to be seeing it when I have a series of lists that should be updating each other, eg:
list 1 has criteria for various giving years,list 2 is "has list 1" plus some other giving in the "OR" section,list 3 is "has list 2" plus yet more criteria in the "OR" section.
The idea is that I should be able to pull list 3 and it should give me an updated count from lists 1 and 2, but when I run list 3 the numbers don't change based on edits to list 1 or 2. If I manually regenerate list 1 or 2, then those updated numbers will pull into list 3. I haven't had time to nail it down in more detail, as I'm focusing on getting these to work so I can run my renewals for this month.
We're down an IT person right now, so I thought I'd post something here real quick: does anyone know of any obvious user errors or setup issues that would cause this? Else we'll escalate to Tessitura help.
Thanks, all!
Beth
From: "James Boncek" <bounce-jamesboncek9049@tessituranetwork.com>To: bvarro@smm.orgSent: Tuesday, July 5, 2011 2:57:28 PMSubject: Re: [Tessitura Technical Forum] Dynamic List problemsHey Dale! A very clear solution to me. Although it would get you by, doesn't that defeat the purpose of including dynamic lists? JamesFrom: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com>Sent: 7/5/2011 2:40:20 PMBeth, I don't know exactly what your criteria are for your lists but I would probably try to combine them into one using the manual edit function - then make that list dynamic. Using graphical edit you can only have one UNION (OR) but if you use manual edit you can have multiple without having to reference other lists. For example, lets say I wanted a list of constituents where: Constituency = 1 OR Membership Current in (x,y,z) OR Contribution Date >= 6/30/2011 I would select the criteria of each one and then copy and paste the code into a new list - making sure to put a "UNION" between each bit of code: Select Distinct a.customer_no From t_customer a (NOLOCK) JOIN vxs_const_cust e (NOLOCK) ON a.customer_no = e.customer_no Where IsNull(a.inactive, 1) = 1 AND e.constituency in (1) UNIONSelect Distinct a.customer_no From t_customer a (NOLOCK) JOIN V_MEMBERSHIP_CURRENT e (NOLOCK) ON a.customer_no = e.customer_no Where IsNull(a.inactive, 1) = 1 AND e.memb_level in ('X','Y','Z') UNION Select Distinct a.customer_no From t_customer a (NOLOCK) JOIN vs_contribution e (NOLOCK) ON a.customer_no = e.customer_no Where IsNull(a.inactive, 1) = 1 AND e.cont_dt >= '2011/06/30' Let me know if that's clear. Would be glad to explain futher.Dale--View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/4809/15758.aspx#15758 or reply to this message--This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you! Spam Not spam Forget previous vote
Hey Dale!
A very clear solution to me. Although it would get you by, doesn't that defeat the purpose of including dynamic lists?
James
From: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com>Sent: 7/5/2011 2:40:20 PM
Beth,
I don't know exactly what your criteria are for your lists but I would probably try to combine them into one using the manual edit function - then make that list dynamic. Using graphical edit you can only have one UNION (OR) but if you use manual edit you can have multiple without having to reference other lists.
For example, lets say I wanted a list of constituents where:
Constituency = 1 OR Membership Current in (x,y,z) OR Contribution Date >= 6/30/2011
I would select the criteria of each one and then copy and paste the code into a new list - making sure to put a "UNION" between each bit of code:
Select Distinct a.customer_no From t_customer a (NOLOCK) JOIN vxs_const_cust e (NOLOCK) ON a.customer_no = e.customer_no Where IsNull(a.inactive, 1) = 1 AND e.constituency in (1)
UNIONSelect Distinct a.customer_no From t_customer a (NOLOCK) JOIN V_MEMBERSHIP_CURRENT e (NOLOCK) ON a.customer_no = e.customer_no Where IsNull(a.inactive, 1) = 1 AND e.memb_level in ('X','Y','Z')
UNION
Select Distinct a.customer_no From t_customer a (NOLOCK) JOIN vs_contribution e (NOLOCK) ON a.customer_no = e.customer_no Where IsNull(a.inactive, 1) = 1 AND e.cont_dt >= '2011/06/30'
Let me know if that's clear. Would be glad to explain futher.Dale
Even if you did know SQL, the object oriented relationship is the key. For example: suppression lists;
Some day you may need to update your suppression criteria, if you hard code the criteria into all your lists, you'll need to update all your lists VS if you include a dynamic Suppression list, you can update that list and all the rest are set.
Problem is, that the suppression list doesn't generate automatically whenever is its called from another list == dynamic fail.
I ran into this same problem a couple years ago with regards to keeping current numbers on a suppression list. My solution was to schedule the "Generate a List" utility to run nightly for a few key lists. This way you can also scan your high priority lists (subscribers, VIPs, etc.) and know they are up to date even if you haven't used them in a while.
~Dan
After discussing it, that does sound like the next best solution. Considering you haven't found any better workaround, I think i'll implement that asap.
Thanks for the tip.