People Filters

VSys One lets you define your own filter criteria in many places, including:

Generally these places have an Add another filter link, which is how you add the first and later criteria to your filter. The layout of the tool can vary, some displaying more options than others, depending on where the filter is being used.

Initial criteria

The values you set here are the most efficient and fast. VSys first finds the people who match these criteria, and then further narrows them by any other filters you add.

Initial source - this is where VSys will start its search for people to include.

Options here may include, depending on where the filter is used, All people in the system, People on one or more lists, People registered in this project, People with specific certifications, Volunteer hours, Assignments, Trainings, Mandates, Interviews, Memberships and Account records.

After selecting an initial source, VSys will give you a list of possible filters which will vary depending on the source you selected. For example, selecting Volunteer hours will give you options for filtering on the person's gender, age, group and type, as well as on the hours record's job/job group and date.

Additional filters

You can add any number of additional filters to further winnow down the people who were selected in the initial criteria above. Below you can see for example, that starting with Addresses/contact information, will allow you to choose more specific pieces of data within that category.

Addresses/ contact info

Addresses

Filter on the presence, validity and completeness of addresses for this person.

Contact flags

All/Any/None of the contact flags you specify.

E-mail address

Include only those with a valid e-mail address or Exclude those with a valid e-mail address.

Phone number

Include only those with a valid phone number or Exclude only those with a valid phone number.

State/county

Comma-delimited lists of states and counties. Only people with addresses matching both of these fields are included.

Zip/postal code

List one or more zip/postal codes, separated by commas. People who have any address with one of these zip/postal codes will be included.

Zip/postal code proximity

Given one or more zip/postal codes separated by commas, VSys finds any other zip/postal codes within the given distance of these, and which are in the states/provinces that you provide. It then goes and finds all people who are in any of this larger list of zip/postal codes.

 

Custom application forms

Requires the presence of specific types of custom application forms during the dates you specify.

Dates

Date person created

Date range for the person's Date created.

Date person active

Date range for the person's Date active.

Date person started

Date range for the person's Date started.

Last changed

Date range for the person's Last changed.

 

Groups and types

Additional group

Person must have one or more of these as his additional groups.

Additional type

Person must have one or more of these as his additional types.

Primary group

Person's primary group must be on this list.

Primary type

Person's primary type must be on this list.

 

 

Hours

Completed hours/assignments

Count of completed assignments (hours records) within the given time period. An hours record for 15 minutes counts as one completed assignment, one for 12 hours counts as one assignment. Leave the start date empty for no minimum date, end date empty for no maximum date, or both empty for any dates at all.

First volunteer hours

Date range for the date of the very earliest hours record posted for this person.

Hours volunteered

Sum of volunteer hours during a given time period, optionally filtering on job.

Last volunteer hours

Date range for the date of the very last hours record posted for this person.

Months with hours

Count of months during the given time period in which the person did some minimum number of hours, optionally including bonus hours as qualifying.

Years with hours

Count of years during the given time period in which the person did some minimum number of hours, optionally including bonus hours as qualifying.

 

Jobs and assignments

Assignment

Count of job assignments filtering by date, job, type, status, etc.

Current assignment or checked in

Person must have an assignment or be checked in for a job as of the date and time you select.

Excluded job

If the person has been specifically excluded from doing one or more of the jobs you select.

Job assignment and/or association

Either or both of a job association or job assignment for one or more jobs on a given date or in a date range.

Job association

Presence or absence of job associations with specific criteria.

Missed assignments

Count of missing assignments between two dates.

Recurring assignment end

One or more recurring assignments whose extension date is between two dates.

Supervisor

People with these supervisors either for job associations or assignments.

 

Others

Account balance

Sum of records in the given accounts during an optional time period within a given range.

Account records

Count of account records in given accounts and types during an optional time period.

Availability

Available on specific dates/times.

Awards received

Received awards of specific types.

Certification

Has one or more certifications of the selected types. Allows filtering on the detailed values within each certification.

Certification expired or missing

This is the opposite of Certification: it returns only people who do not have the selected type of certification, or who have that type of certification but it's expired or not yet effective on the date that you specify.

Comments attached

Either those with or without comments of specific types during a time period.

Interview

Person has interview of specific kinds, statuses, results and dates.

Last award

Person's most recent award is or is not of this type and within a specific time window.

Letter sent

Person has been sent or not sent letters. Allows detailed filtering on the letters themselves.

List

On all/none/any of a specific set of lists.

Mandate

Presence of mandates with specific criteria.

Membership

Presence of memberships with specific criteria.

Printed name tag/credential

Has or does not have a valid credential/name tag.

Relationship

Presence or absence of relationships of specific kinds.

Survey response

Responses that this person has made to specific questions using surveys. Anonymous answers are not considered here.

Training

Has or does not have training. Allows detailed filtering on the trainings themselves, including status.

 

Personal properties

Age

Person's age on the current date.

Communication language

Person's communication language, regardless of any other languages he speaks.

Company

Requires that the person have a Company field which begins with the value here. Note: this is not a relationships search, it works solely on the Company field in the profile editor.

Custom field

For any global or project custom field, lets you specify the values or absence of values for that field.

Date of birth

Specifies the valid range for the person's DOB. To send out birthday post cards, check the box Ignore year portion of date. Then set a DOB range from 01/01/2001 to 01/31/2001, and all people who were born in January of any year are included.

Entrant image

Include entrants with images or Exclude entrants with images. This refers to the person's portrait photo.

Gender

Male, Female, and Unknown.

Job preferences

All/Any/None of the job preferences you set. You can require that these preferences are in a certain rank range, and so include only people who have them at the top of their preferences.

Language

All/Any/None of these languages. The person can have this as his primary or additional languages and qualify.

Person is "team"

Exclude people who are teams and Include only people who are teams.

Person name elements

Advanced filters on the aspects of a person's name: Last/family, First/given, Middle, Prefix/honorific, Suffix/generation, Team.

Primary language

Person's primary language, regardless of any other language he speaks.

Security user

If VSys security is enabled, filters for including and excluding security users by status, superuser status, and user IDs.

Skill

All/Any/None of these skills.

Special need

All/Any/None of these special needs/requests.

Volunteer source

All/Any/None of these volunteer sources.

Volunteer type

All/Any/None of these volunteer types.

Wheelchair/requires handicap access

Include only entrants requiring a wheelchair or Exclude entrants requiring a wheelchair

 

Projects

Project registration

All/Any/None filters on the person's registration within a checklist of projects with specific roles

Project registration by date

Include or exclude people based on their registration within any projects within a date range.

 

Statuses

Active status

Include or exclude people on their status: Active, Inactive, Prospect or Applicant, etc.

Archived

Include only archived people or Exclude archived people

Banned

Include people on banned list or Exclude people on banned list

Deceased

Include only deceased people or Exclude deceased people

Inactive

Include only inactive people or Exclude inactive people

Inactive date

Date range for the person's Inactive date field.

Inactive followup date

Date range for the person's Inactive followup date field.

Placeholder

Include only placeholder people or Exclude placeholder people

Trace/audit log actions

Things that have been done/to this person's record.

Trace/audit log actions as operator

Things that this person has done as a signed-in user of VSys.

Transitions

Transitions (changes) of the person's active status, gender, group, type, volunteer type, deceased, banned, archived and other similar properties.

Years since first started

Requires that the number of full years between the current date and the person's Date started be within a certain range.

 

Web/kiosk

Kiosk currently logged in

Include or exclude people who are currently logged in via the touchscreen/kiosk or were on a particular date.

Kiosk user ID

Only people with a kiosk account or Exclude people with a kiosk account

Kiosk or web login ID

Only people with a kiosk or web account or Exclude people with a kiosk or web account

Web user ID

Only people with a web account or Exclude people with a web account