Cannot query on staffing resources filled by staff

Staffing resources can be filled by volunteer, staff, or board members.  When a staffing resource is filled by staff or board members, you are unable to report on the constituent that filled that job.  You have to go to the Event, Resources tab to see who filled the staffing resource.
 We are currently evaluating this issue and will update this article when we have more information.

Alternative Solution: Go to the program event record, Resources tab.  In the Filled by column, see what staff or board members filled this staffing resource.
 Use another field like the event description field to track the resources, so you can output this information in a query.

Steps to Duplicate

Steps to duplicate in sample database: 
  1. Add a staffing resource on a program.
  2. Add an event.
  3. Go to the Resources tab.
  4. Edit the staffing resource and fill it with staff people.
  5. Go to Analysis > Information Library.  Add a program query.
  6. On the left, expand Staffing Resource.
  7. Output the Filled by field, but see that it just says Staff, not specific names.
  8. Under Staffing Resources, if you expand Assignments, there is only a Volunteer Node, not a Staff Node.
  9. Repeat this same process with a staffing resource query or sales order query.



Was this article helpful?