To create a Query, you would perform the following steps:

1. Open the Mail List - List window.

   

   For more information on accessing the Mail List window, click here.

2. Click the New button.

   The Mail List Criteria (inserting) window opens.

   

3. In the Name field, enter a short name for the Mail List.
4. Make a selection for the names to be included on the list.
5. In the Description tab, select the appropriate flags and in the description field, enter a detailed description for the Mail List.

   This is extremely important for other users who may use the mail list. If the description of the list is good it will not need to be deciphered to understand the reason for the list.

   

6. Click the Save button.

You can now enter the Criteria.

7. Click the Criteria Groups Tab.

   

8. Click the Create Group button.

   

9. Choose To Add Patrons To The Mail List.

   The Mail List Data Selection window opens. To search for data, you must select a file for the primary source of information for the mail list. Theatre Manager will include information in related parent files.

   Patron Data is the PARENT for most data stored in Theatre Manager. When defining criteria, if you select any file as the main file, you can also set criteria for the patron record. However, the converse is NOT true. Selecting the patron file as the Merge File, it does not include the child information - such as donor inormation.

   

   Select a file that contains the data you are searching for. As the example list is searching for patrons who have made donations; the file to use would be "Patron Address Link". Click here for more information on selecting the file.

10. Select the "Patron Address Link" file..
11. Click the Next button.

    The Parameter window opens.

    Click here for more information on this window. This tab displays the added criteria for the query on the database.

    

12. Click the New button.

    The Add/Edit Parameter window opens.

    

    The list contains all the possible searchable fields available in your selected file. The selections on the top left side of the window (and, or, not) are used for searching multiple fields when more then one line of criteria is added within the same file. Click Here for an overview of conditions and search criteria.

    

13. Select the field to search.

    In this example "Patron Addresses>>Address Line 1", will be the selected search field criteria.

14. Select a condition, in this example "is not empty".

    The condition displayed above will find any patron has aan entry in the street address section of the Patron Record.

15. Click either:
    1. Add / Continue if adding another search criteria to the file.

       The Criteria window remains open until save or cancel is clicked.

    2. Save if the search criteria for this file is complete.

       The Parameter window will return and the entered criteria will appear in the list.

    3. Under Exclude Records, enable the "Don't Mail-Theatre Requested" and the "Don't Mail-Patron Requested" flags, and click the Done button.

       

       Now the group and its criteria have been added to the main query. For this example, another group needs to be added to include the patrons who have email addresses.

       

    4. Click the Create Group button.
    5. Choose To Add Patrons To The Mail List.

       Choose a file containing the required data. This example requires the "Patron Contact Link" file.

    6. Click the Next button.
    7. Click the New button in the Parameters window.

       In the Edit/Add Parameters window, leave the And button selected. The field for this example would be "Patron Contact Data>>Contact Data (eg Phone/email/website)" while the condition would be "contains" and parameter would be "@" (to search for an email address).

       

    8. Click the Save button.

       

    You are returned to the Parameters window.

    9. Click the Done button.

       

       Both of the Search Criteria are added to the query. The group criteria says add any patron who has volunteered their time as well as any patron who has made a donation to the list.

       Now, all the criteria have been added to satisfy the description, the database can be searched.

    If you have criteria that you'd like to print and save, while on the tab, click the PRINT button at the top of the window. You will get a report that you can then print or save to PDF. This can be handy when you: Want to keep a printed format of your Mail List criteria Want to share your criteria with others in the office who may not use Theatre Manager Want to email the precise criteria you have been working on to support@artsman.com to ask for help. Emailing a PDF is preferred as it shows all of the criteria, the Description (so we know what you are trying to accomplish), the conjunctions (AND, OR, NOT) and operators (is between, is greater than, is equal to, etc.) used in the criteria. This is the preferred method for Support to receive your criteria help request.

    10. Click the Execute button to begin the Query.

        The patrons satisfying the first criteria will be found and added to the list. Once complete, the second criteria will be performed and any patrons matching the second criteria will be added. Any patron matching both criteria will only be displayed once. The Mail List will default to the Who's In tab displaying all patrons who match the criteria and are in the list.

        

If you are designing a very specific mail list you will need to use some complex criteria to ensure you receive the desired data. Complex criteria uses brackets combined with operators and conditions to find specific groups of data. Click Here to view the different types of operators and conditions along with a description of their function.

After creating mail list criteria and building the mail list, over time some of the patrons on the mail list may no longer meet the criteria to belong to the mail list. The most effective way to remove the patron that no longer meet the criteria is to rebuild the list.

1. Open the Mail List Window.

   Click Here to learn how to access this window.

2. Find the mail list you would like to rebuild.
3. Click the Execute button.

   The following warning screen will open.

   

4. Click the Rebuild button.
5. Click the Yes button.

   This will remove the current patrons from the list and perform the query again on the new data. Clicking Proceed would have left all current patrons in the list, added patrons who fit the entered criteria and only remove patrons who fit within any "remove" criteria.

Parts of the Criteria for Group from Mailing List Window

	Default search or sort order for the selected Parameters.
	Inserts the last used criteria for the merge field selected.
	Displays saved criteria options within the selected merge field.
	Saves selected criteria.
	Saves the entered criteria to be used again.
	Opens the criteria window to insert new criteria.
	Opens the criteria window and allow for modifications.
	Removes the selected line of criteria.
	Removes all lines of criteria in the parameters window.
	Inserts brackets around lines of criteria.
	Removes brackets around lines of criteria.
	Searches the database for patrons who "have" a specified line of criteria. Having criteria is criteria that is based on aggrigate values within the search. Click here for more information on using Having.
	Cancels the entry of criteria.
	Completes the entry of criteria.

If you wish to remove a large number of patrons from a list and they all have a common feature, using a query is the best technique. It is the same procedure as adding a new group except for selecting the Remove function. To ensure that you are removing the correct patrons, place the remove criteria group as the last group to be performed. Click here to learn how to rearrange groups.

1. Open the Mail List Window.

   Click Here to learn how to open the window.

2. Find the mail list you want to remove the patrons from.
3. Click the Criteria Groups tab.

   The Criteria Groups for the selected mail list are displayed.

   

4. Click the Create Group button.
5. Choose "To Remove Patrons From The Mail List".

   The group selection dialog opens.

   

   Select a file which contains data all patrons to be removed from the list have in common.

   Using the Example List created in Adding Patrons to a Mail List Through a Database Query patrons with last names starting with the letter A will be removed.

   The "Patron Data" file will be used for this example.

6. Select "Patron Data" from the drop-down list and click the Next button.

   The Parameters window opens.

   

   Click Here for a detailed description of the window.

7. Click the New button.

   The Add/Edit Parameters window opens.

   

8. Select the field to search by.

   For this example the "Patron Name-Last " field.

9. Fill the search parameters with the information to search by.

   For the example use "begins with A".

10. Click the Save button.

    The Parameters window returns and the selected criteria will appear in the window.

    
11. Click the Done button.

    The Mail List Criteria window returns.

    
12. Click the Execute button.

    An Options dialog opens.

    

13. Click the Rebuild button.

    A confirmation dialog is displayed.

    

14. Click the Yes button.

    Theatre Manager will highlight each group as it is executed.

    The Mail List Criteria window opens to the Who's In tab. Patrons with last names starting with the letter A will now be removed from the list.