Hello All,
I have a constituency with a start and end date that has passed. I want to pull a list of those records.
My list criteria is as follows:
Constituency - IN - student
Constituency End Date - = - 5/16/13
This is not giving me any results. What step am I missing?
Thanks,
Marie Kocher
Development Assistant
Kansas City Ballet
500 W Pershing Rd
Kansas City, MO 64108
(816) 931-2232 x 1382
mkocher@kcballet.org
Beth – You and I are on the same track. I had it on my list of suggestions to talk to my DBA.
Marie
--
Marie Kocher | Development Assistant
Todd Bolender Center for Dance and Creativity
500 W Pershing Road
816-931-2232 x 1382 | 816-931-1172 (fax)
Buy tickets and enroll for classes: www.kcballet.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Beth Gilliland Sent: Wednesday, August 28, 2013 2:11 PM To: Marie Kocher Subject: RE: [Tessitura Development Forum] Pulling Constituency withe End Date
Hi Marie!
You can see where your list criteria is pulling it's data from. When you are creating a list, right-click on the criteria element (say, "Constituency") and you'll see the "Detail Table" that it is pulling from.
If the Detail Table is "vxs_const_cust" - it will NOT pull your inactive constituencies - even if it is a constituency in the future! This could be the root of your trouble.
It's my recollection that when we started with Tessitura, we only had one criteria element that referred to this table and only pulled current constituencies. I added three new elements -- Constituency(Archive),Constituency(Archive) Start Dt, Constituency(Archive) End Dt -- so I could pull ANY constituency, whether expired or not. It will probably require the assistance of your DBA and a new secure view -- but it would keep you from doing a lot of list criteria gymnastics to get what you're after.
Help on adding criteria can be found here: http://www.tessituranetwork.com/Help_System/Content/System_Tables/T_KEYWORD.htm
Beth
From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com> Sent: 8/27/2013 4:00:17 PM
Yes, I did try different operators. Thanks for the suggestion. I think it is something on my end “behind the scenes.”
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens Sent: Tuesday, August 27, 2013 1:48 PM To: Marie Kocher Subject: Re: [Tessitura Development Forum] Pulling Constituency withe End Date
Are you sure your constituency end date for all the records you are looking for is 5/16/13? Maybe you want to use BETWEEN or GREATER THAN rather than equals.
From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com> Sent: 8/27/2013 1:09:52 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!