Forgive me, our org has no database administrator. I am putting this in the Education field because we rely heavily on education constituencies to track our artists and I would like to be sure I can report accurately.
I would like to build an extraction set using constituencies as my criteria. Example: I want to find all people with a committee member constituency end date before 6/30/12. Here is what my criteria looks like:
Constituency end date <= 06/30/2012 (AND)
Constituency has 10 values selected...(whatever the constituency is)
Right now our database only pulls current constituencies (no end date). For instance, this extraction is pulling up one person that has a start date of a committee constituency on 1/4/12. I have gone through the extraction videos and I don't think I'm doing anything wrong. Perhaps someone out there would disagree or have some suggestions?
Thanks for your time,
Halley
Hi Halley,
You seem to be using the wrong operator for your Constituency criterion. You should be using IN, not HAS. By using HAS it is looking for people with any constituency with an end date on or before 6/30/12 and also one of the constituencies you selected with any end date. By using IN it will combine the two so that a constituent must have one of the constituencies you selected with an end date on or before 6/30/12.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com