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
Hi Marie,
I ran into a similar issue once. It was in v10 and it certainly could have changed in v11, so if I'm wrong hopefully somebody will correct me.
I believe that when you use the criteria "Constituent IN (whatever)" you're actually pulling from a database view that is already filtering to include only accounts that currently have that constituency. If I pull a list with just "Constituency IN Advisory Board" e.g., and don't specify start/end dates, I get a list of only the current advisory board. (In fact, I don't seem to have "Constituency End Date" in my List Builder, so that may be custom?)
If the Constituency criteria is pulling from the view vxs_cust_cont, I think you might need to manually edit the query to pull straight from the actual table, tx_const_cust instead, and then you could use start/end dates. (But if you're using custom list criteria already maybe you already have a workaround for this.) I'm definitely not a DBA so maybe somebody with a little more knowledge of the v11 backend can chime in with more useful advice. :)
Good luck!