Hello all,
We add a "Academy Student" constituency to all of our Ballet School Student records. The start date for the constituency is the first day of classes, Aug 31 - thus, a future date from today.
I need to pull a list of these students today, however my list returns no records.
How can I pull a constituency with a future date? Furthermore, how can I pull a constituency with a past end date?
Thanks,
Marie Kocher
Development Assistant
Kansas City Ballet
Todd Bolender Center for Dance & Creativity
500 W Pershing Rd
Kansas City, MO 64108
w 816.931.2232 | d 816.216.5582
Not sure if I'm adding to the prior posts, but this query works for me- SELECT distincta.customer_noFROM TX_CONST_CUST aWHERE a.constituency=77 and a.end_dt<'2014-9-1' It catches all people with a constituency that ends prior to Sept 1 2014. MeganFrom: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>Sent: 2/1/2016 2:12:54 PMI'm trying to add a Constituency End Date to the list criteria so I can pull a list of people who have expired Subs constituencies. I have Constituency Start Date but no End Date. I have added the Constituency End Date to the T_Keyword table. I have tx_const_cust as the Detail Tbl. !.end_date as the Detail Col. I did find a message from Kevin that said make sure the new entry references the view not the table but I tried vxs_const_cust and I got an error message. I switched it to tx_const_cust and got the same error message. What am I doing wrong? Thx in advance. --View this message online at http://www.tessituranetwork.com/Community/forums/p/14250/46394.aspx#46394 or reply to this message Adria Gunter | Subscriptions and Groups Manager STUDIO THEATRE 1501 14TH ST NW WASHINGTON DC 20005 T 202-232-7267, ext. (365) F 202-588-5262 www.studiotheatre.org Subscriptions are online! Reserve your group of 10+ today and enjoy a discount! 2015-2016 SEASON MAIN SERIES CHIMERICA |THE APPLE FAMILY CYCLE: SORRY & REGULAR SINGING | BETWEEN RIVERSIDE AND CRAZY | MOMENT | HEDDA GABLER 2015-2016 SEASON STUDIO X ANIMAL | CONSTELLATIONS 2015-2016 SPECIAL REMOUNT BAD JEWS
Not sure if I'm adding to the prior posts, but this query works for me-
SELECT distincta.customer_noFROM TX_CONST_CUST aWHERE a.constituency=77 and a.end_dt<'2014-9-1'
It catches all people with a constituency that ends prior to Sept 1 2014.
Megan
From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>Sent: 2/1/2016 2:12:54 PM
I'm trying to add a Constituency End Date to the list criteria so I can pull a list of people who have expired Subs constituencies. I have Constituency Start Date but no End Date. I have added the Constituency End Date to the T_Keyword table.
I have tx_const_cust as the Detail Tbl. !.end_date as the Detail Col.
I did find a message from Kevin that said make sure the new entry references the view not the table but I tried vxs_const_cust and I got an error message. I switched it to tx_const_cust and got the same error message. What am I doing wrong?
Thx in advance.
Adria Gunter | Subscriptions and Groups Manager
STUDIO THEATRE
1501 14TH ST NW
WASHINGTON DC 20005
T 202-232-7267, ext. (365)
F 202-588-5262
www.studiotheatre.org
Subscriptions are online! Reserve your group of 10+ today and enjoy a discount!
2015-2016 SEASON MAIN SERIES CHIMERICA |THE APPLE FAMILY CYCLE: SORRY & REGULAR SINGING | BETWEEN RIVERSIDE AND CRAZY | MOMENT | HEDDA GABLER
2015-2016 SEASON STUDIO X ANIMAL | CONSTELLATIONS
2015-2016 SPECIAL REMOUNT BAD JEWS
Worth noting that the syntax catches anyone with an expiration prior to 8/31. So if you want to catch people w/ 8/31, the end date needs to be <9/1/16. Is that by chance the issue?
I don't believe that any table modifications were made for that query to work in our system.