My organization just added a list element for start and end dates for constituencies. Our purpose for doing so was to track members of our High School All Stars Band throughout the years and get snapshots of which students participated in which year. However, after pulling the list, we realized that Tessitura does not pull inactive constituencies. So if we had a student participate from 2009 to 2010 (start date of >= 7/1/2009 and end date of <= 6/30/2010, let's say), they would not come up on the list since that is now an inactive constituency.
Is there a way to create a list element to INCLUDE inactive constituencies? Or perhaps manually edit the SQL within the list builder to include them?
Lizzie,
There was a recent posting about this here:
http://www.tessituranetwork.com/Community/forums/t/7716.aspx
You could do a manual edit but if its something you want to do on a regular basis, it might be easier to set up a new list manager criteria or two.Dale
Lovely! It worked!! Thanks so much :)