• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 187 views
  • Users 0 members are here
Related

Program Name in list criteria

Jennifer Vinson
$organization

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!

Parents
  • $organization

    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 a criteria for Program Listing Name
    • then use the operator 'LIKE' and leave the percent sign as a wild card in the associated field next to LIKE

    Add this row to your list in which you are looking for those without a salutation as you noted, should work. 

  • $organization in reply to Jenny Carvo

    I will try that, thank you!!  I haven't investigated the like and the % things yet. Can you explain what those things mean? 

  • $organization in reply to Jennifer Vinson

    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 characters
    So %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

Reply
  • $organization in reply to Jennifer Vinson

    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 characters
    So %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

Children