We are coming up on a 50th anniversary and I would like to create an output set to tell me how many years our current subscribers have subscribed. I was able to find an old thread that Dale posted (11-23-2010) with information to create a query element for contributions and it worked beautifully. For instance I see that there are donors who have given 32 years going back to 1987 the first year that we have historical information for contributions in Tessitura. And not all are major donors. I will let the development department figure out how to spin it.
Is there something similar for pkgs? I tried to use the same parameters changing some of the language for pkgs ( but do not have enough knowledge to trouble shoot the error messages) and continued to get error messages so just deleted the row in query element. We may have changed how we create sub packages since our conversion several years ago.
Any other suggestions?
Michelle
Unknown said: We are coming up on a 50th anniversary and I would like to create an output set to tell me how many years our current subscribers have subscribed. [...]
We are coming up on a 50th anniversary and I would like to create an output set to tell me how many years our current subscribers have subscribed. [...]
We had our 50th anniversary last summer, and in preparation for that we wanted to find 20 or more year subscribers (I wish our digital subscription data went back 30,40, or 50 years!). For that I created a "20+" constituency for subs with 20 or more seasons in LVS_SUB_HIST, which is checked nightly along with the rest of our custom constituency maintenance code.
If this code sounds interesting, please e-mail me offline.