Hi Guys,
We are just starting to incorporate active dates into our postal address TAB in Tessitura and filter by these for mailings.
I can’t seem to see an ‘out of the box’ filter criteria in list manager to use for an extraction.
Do we have to create one? If so that’s fine our SA can do that – but I just wanted to check I wasn’t looking in the wrong area or under the wrong title.
(the logical side of my brain says it should be ‘postal address active date’ or the like??)
Would love some info on this
Cheers!!
Hi Andrea,
If you want to pull constituent records based on people with Florida address active in the fall, you will need to add some additional criteria to T_KEYWORD that looks at the active months on addresses. For details on adding criteria to T_KEYWORD see the following help topic:
http://www.tessituranetwork.com/Help_System/Content/System_Tables/T_KEYWORD.htm
I just realized, though, that it might be tricky to add a criterion that looks at the active months, based on the way the data is stored (an array of 12 Ys or Ns). I’m going to ask my coworkers for some thoughts and get back to you with some more specifics. Or if you have good IT resources internally, you could ask them for help while you are waiting to hear back from me.
Kevin Sheehan
Senior Documentation & Learning Resources Specialist
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
Hi Kevin,
Thanks for the help! I think we may have added a criterion some time ago called "Month Array Jan thru Dec", I am not sure if this comes standard or not. Yes, you pinpointed my exact issue with the criterion, dealing with the "Y" and "N". I thought trying a wildcard character in the Dec-Sept (the months that don't affect my pull) would work, but it did not.
Unfortunately, we do not have a good IT resource internally. Please let me know if your coworkers have any insights on this issue!
Thank you!