Can anyone tell me if there is a way to pull a list where the Program Name is not blank?
More specifically, I'm trying to get a list of records that have a Program Name, but do not have a specific internally made saluation. I was able to get the specific salutation "does not have", but can't find how to get the Program Name is not blank. Prior to my arrival we had two teams tracking program names in different places and I need to clean it up.
Thank you!
Hi Jennifer -
Jenny here from the Tessitura Support Team.
To get a list of folks who have a program name that isn't blank, let's try the following:
Add this row to your list in which you are looking for those without a salutation as you noted, should work.
I will try that, thank you!! I haven't investigated the like and the % things yet. Can you explain what those things mean?
Like is an operator similar to =, IN, NOT IN, HAS, < etc. It's used in combination with the Wild Card % which represents any string of charactersSo %eath would find Heath and Underneath and any thing that has and eath at the end of it. The % stands in for the H and Undern in the result. Heat% would find Heath and Heather and anything with Heath at the beginning. NB/ in searches like the constituent search there is an assumed and unseen % at the end of the string that you type to search.
So using it in Program Listing Name Criteria you are asking "I would like all records with a Program Listing Name like % (ie: anything)"
Now if you have people with a Program Listing entry but a blank in the Prefered name field, and you want to exclude those (or something else missing) then we can modify that search
Here is the Tess v15.1 documentation explanation which is great.
When using the LIKE operator the value of data on constituent records must match the value entered, but a wildcard character, like the % sign, can be used to represent any character.
https://www.tessituranetwork.com/Help_System_v151/Content/Criteria%20Sets/LIKE%20NOT%20LIKE.htm
Heath,
Thank you! You had me a "wild card", I am familiar with that function, but didn't know that's what this would be doing...or that it could do that without any other text, but makes total sense. Sometimes I just overthink things. :-)
Me too. Glad i could help