Start your query: 
  1. Go to Analysis > Information Library 
  2. Click Add an ad-hoc query. 
  3. Select the source view of Programs Note: You can also follow these steps with other source views if needed, just make sure you add the following fields from the Program Events node. 
Add fields to Results Fields to Display:
Although this is not typical, we will start by adding fields to Results Fields to Display first. We will be using the fields in the Results to help us in Include Records Where. 
  1. We will start by adding the following fields for basic information about your program events. In the left column, highlight Program Events. From the middle column, drag the following fields to Results Fields to Display: 
    1. Name
    2. Start Date 
    3. Start Time
    4. End Time 
  2. Next we will add the volunteer information. Expand Program Events and highlight Event Staffing Resources. From the middle column, drag Name to Results Fields to display. This will display the name of the job the volunteer will do. Your field will appear like this: Program Events\Staffing Resources\Name
  3. Next, we will want to add a field to display the name of the volunteer assigned. In the left column, expand Event Staffing Resources where it is highlighted from Step 5. Next, expand Job, expand Occurrences, expand Assignments and highlight Volunteer. From the middle column, drag Name to Results fields to display. Your field will appear like this: Program Events\Event Staffing Resources\Job\Occurrences\Assignments\Volunteer\Name
  4. You can also add any additional fields you need to see in the Results. For example, Program event Location, Program event capacity, etc. 
Add fields to Include Records Where:
  1. First, we will need to add a filter in order to see the upcoming scheduled events. In the left column, highlight Program Events. From the middle column, drag Start Date into Include records where. Set this field to be equal to or between the date range you need. For example, "Program Event\Start Date is equal to this week."
  2. Next, we will need to add a field in order to display the correct volunteer name. Highlight Assignments where we expanded it in step 6. From the middle column, drag Assignment date to Include Records Where. 
  3. Set Assignment Date to be equal to an output field and select this to be equal to Program Event\Start Date. Apply criteria
  4. Next, if you also want to include events without volunteer assignments, drag the same field (Assignment date) back to Include Records and set this to be blank. Surround these two assignment dates in parenthesis and add an OR statement. Your fields should appear like this:                                                    User-added image
  5. (Optional) If you're looking for only a specific category of programs, in the left column, highlight Program query at the very top. From the middle column, drag Category to Include records where. Set this to be equal to or one of the categories you are looking for. For example, "Category is one of Adult Classes, Child Classes"
  6. (Optional) If you're looking for only a specific program, in the left column, highlight Program query at the very top. From the middle column, drag Program record to Include records where. Search for the program you are looking for. For example, "Program Record is equal to Painting Class."
Here is an example of how a final query might look: 
Example of final query