You can refine the number of records displayed to only the ones containing specific data using a filter. Filter icons appear below the field names in data grids.
If you click the filter icon below a field name, the filter dialog will appear with a list of filtering options.
Filter Options
You can apply filters on multiple columns in a data grid to specify which data is presented. Column filters in a given data grid depend on the type of data in each column. The filter options for data types are detailed below. Data types include:
- Boolean Columns - Examples = True, False
- Date/Time Columns - Examples = 02/10/1981, 11/09/2010
- Numeric Columns - Examples = 1, 400, 7900, 3.4
- Text Columns - Examples = "cat" and "The cat ran to the supermarket fast!"
- Checkbox filter- Examples= Selecting the box next to year and certification to pull up only those two columns.
Boolean Columns
The following Boolean filters can be applied to columns with Boolean data. In the filter explanations below, the term "provided value" refers to the value that you yourself must enter as filter criteria.
Note: Columns default to “Show All” if a filter is not applied, displaying all records.
-
Checked - Filter to include only records that contain "true" in the column. In this case you do not have to provide any filter criteria yourself, as the value "true" will automatically be used for the filter criteria.
- Example: You are viewing the Staff Management grid and only want to see records for staff members who are Administrator Users in SchoolFront. You can apply the "True" filter to the Admin column and only staff members who have the Admin role in SchoolFront will display.
- Example: You are viewing the Staff Management grid and only want to see records for staff members who are Administrator Users in SchoolFront. You can apply the "True" filter to the Admin column and only staff members who have the Admin role in SchoolFront will display.
-
Unchecked - Filter to include only records that contain "false" in the column. In this case you do not have to provide any filter criteria yourself, as the value "false" will automatically be used for the filter criteria.
- Example: You are viewing the Staff Management grid and only want to see records for staff members who are not Counselors. You can apply the "False" filter to the Counselor column and only staff members who are not Counselors in SchoolFront will display.
Date/Time Columns
The following Date / Time filters can be applied to columns with Data / Time data. In the filter explanations below, the term "enter value" refers to the value that you yourself must enter as filter criteria.
Note: Columns default to “Show All” if a filter is not applied, displaying all records.
BY TIME PERIOD
- Last Year- Filter to include only records that contain a date that falls in the previous year. In this case you do not have to provide any filter criteria, as today's date will automatically be used for the filter criteria.
- Last Quarter - Filter to include only records that contain a date that falls in last quarter’s date range. In this case you do not have to provide any filter criteria yourself, as all dates falling in the range of the previous quarter will automatically be used for the filter criteria
- Last Month - Filter to include only records that contain a date that falls in last month’s date range. In this case you do not have to provide any filter criteria yourself, as all dates falling in the range of the previous month will automatically be used for the filter criteria.
- Last Week - Filter to include only records that contain a date that falls in last week’s date range. In this case you do not have to provide any filter criteria yourself, as all dates falling in the range previous week will automatically be used for the filter criteria.
- Yesterday – Filter to include only records that contain yesterday’s date. In this case you do not have to provide any filter criteria yourself, as yesterday's date will automatically be used for the filter criteria.
- Last N Days- Filter to include only records that contain the last set amount of days. In this case you will need to enter a value for the amount of previous days you would like the data to include.
- Past- Filter to include only records that contain a date in the past. In this case you do not have to provide any filter criteria yourself, as today's date will automatically be used for the filter criteria.
- Today – Filter to include only records that contain today’s exact date. In this case you do not have to provide any filter criteria yourself, as today's date will automatically be used for the filter criteria.
- Future - Filter to include only records that contain dates in the future. In this case you do not have to provide any filter criteria yourself, as today's date will automatically be used for the filter criteria.
- Next N Days- Filter to include records that contain dates within a set number of days in the future. In this case, you will need to provide a value for the set amount of day you would like the data to include.
- Tomorrow – Filter to include only records that contain a date that equals tomorrow's date. In this case you do not have to provide any filter criteria yourself, as tomorrow's date will automatically be used for the filter criteria.
- Next Week – Filter to include only records that contain a date that falls in next week’s date range. In this case you do not have to provide any filter criteria yourself, as all dates falling in the range upcoming week will automatically be used for the filter criteria.
- Next Month - Filter to include only records that contain a date that falls in next month’s date range. In this case you do not have to provide any filter criteria yourself, as all dates falling in the range of the upcoming month will automatically be used for the filter criteria.
- Next Quarter - Filter to include only records that contain a date that falls in next quarter’s date range. In this case you do not have to provide any filter criteria yourself, as all dates falling in the range of the upcoming quarter will automatically be used for the filter criteria.
- Next Year - Filter to include only records that contain a date that falls in next year’s date range. In this case you do not have to provide any filter criteria yourself, as all dates falling in the range of the upcoming year will automatically be used for the filter criteria.
BY DAY OF WEEK
- Monday- Filer to include any records that contain data that was created/submitted on a Monday.
- Tuesday- Filter to include any records that contain data that was created/submitted on a Tuesday.
- Wednesday- Filter to include any records that contain data that was created/submitted on a Wednesday.
- Thursday- Filter to include any records that contain data that was created/submitted on a Thursday.
- Friday- Filter to include to any records that contain data that was created/submitted on a Friday.
- Saturday- Filter to included to any records that contain data that was created/submitted on a Saturday.
- Sunday- Filter to included to any records that contain data that was created/submitted on a Sunday.
BY MONTH
- January- Filter to include any records that contain data that was created/submitted in the month of January.
- February- Filter to include any records that contain data that was created/submitted in the month of February.
- March- Filter to include any records that contain data that was created/submitted in the month of March.
- April- Filter to include any records that contain data that was created/submitted in the month of April.
- May- Filter to include any records that contain data that was created/submitted in the month of May.
- June- Filter to include any records that contain data that was created/submitted in the month of June.
- July- Filter to include any records that contain data that was created/submitted in the month of July.
- August- Filter to include any records that contain data that was created/submitted in the month of August.
- September- Filter to include any records that contain data that was created/submitted in the month of September.
- October- Filter to include any records that contain data that was created/submitted in the month of October.
- November- Filter to include any records that contain data that was created/submitted in the month of November.
- December- Filter to include any records that contain data that was created/submitted in the month of December.
BY RANGE
- After – Filter to include only records that contain a date that falls after today’s date. In this case you do not have to provide any filter criteria yourself, as today's date will automatically be used for the filter criteria.
- After or on- Filter to include only records that contain a date that you enter on the date you enter or after. In this case you will have to provide a date for the filter criteria.
- On- Filter to include only records that contain a date that you enter. In this case you will have to provide a date for the filter criteria.
- Not On- Filter to include only records that do not contain the date that you enter. In this case you will have to provide a date for the filter criteria.
- Before or on- Filter to include only records that contain a date that includes the date you enter or before. In this case you will have to provide a date for the filter criteria.
- Before – Filter to include only records that contain a date that falls before today’s date. In this case you do not have to provide any filter criteria yourself, as today's date will automatically be used for the filter criteria.
- Within- Filter to include only records that contain a date that fall before the two dates that you enter. In this case you will need to provide both a start and an end date for the filter criteria.
- Outside- Filter to include only records that contain a date that is outside of the two dates that you enter. In this case you will need to provide both a start and an end date for the filter criteria.
- All Empty- Filter to include records that do not have an entered value within the column.
- All Not Empty- Filter to include all records that have an entered value within the column.
Numeric Columns
The following Numeric filters can be applied to columns with numeric data. In the filter explanations below, the term "provided value" refers to the value that you yourself must enter as filter criteria.
Note: Columns default to “Show All” if a filter is not applied, displaying all records.
EXACT MATCH
- Equals – Filter to include only records that contain the provided value. In this case the "provided value" you type must be very specific and complete. The term "equal" means "exact match," so if you mistype or leave a numeral out, the filter will not find any records.
- Does Not Equal – Filter to include only records that do not equal the provided value. In this case the "provided value" you type must be very specific and complete. The term "equal" means "exact match," so if you mistype or leave a numeral out, the filter will not work properly.
BY PARTIAL
- Begins with- Filter to include only records that contain data that being with the provide values. In this case the "provided value" you type must be the exact content used in the start of the value entry.
- Ends with- Filter to include only records that contain data that ends with the provided values. In this case the "provided value" you type must be the exact content used in the end of the value entry.
BY CONTAINS
- Contains- Filter to include only records that contain the provided value. In this case the "provided value" you type must be a word, phrase, or character(s) used in the value entry.
- Does Not Contain- Filter to include only records that do not contain the provided value. In this case the "provided value" you type must be a word, phrase, or character(s) that is missing in the value entry.
BY EMPTY STATUS
- All Empty- Filter to include all records that do not have a value entered in the column.
- All Not Empty- Filter to included all records that have a value entered in the column.
Text Columns
The following Text filters can be applied to columns with free text data. In the filter explanations below, the term "provided value" refers to the value that you yourself must enter as filter criteria.
Note: Columns default to “Show All” if a filter is not applied, displaying all records.
- Equals – Filter to include only records that completely equal the provided value. In this case the "provided value" you type must be very specific and complete. The term "equal" means "exact match," so if you mistype, misspell, or leave anything (including punctuation) out, the filter will not find any records. If you do not know exactly what you are looking for, the "Contains" filter may be a better choice for filtering using less rigid criteria.
- Example: You are in the Discipline section of the application and want to see all disciplinary records logged for a student named "Ben Affleck." To quickly see all of Ben's records, select the filter icon under the "Student ID" field, then select "Equals." Type in Ben Affleck's complete, unique Student ID and click enter. All records with Ben's complete ID as you typed it will display. All other records will disappear.
- Does Not Equal – Filter to include only records that do not equal the provided value. The term "equal" means "exact match," so if you mistype, misspell, or leave anything (including punctuation) out, the filter will not work properly. If you do not know exactly what you are trying to exempt from display, the "Does Not Contain" filter may be a better choice for filtering using less rigid criteria.
- Begins With – Filter to include only records that begin with the provided value. In this case the "provided value" you type must be the exact content used in the start of the value entry.
- Example: If you want to see all science courses in the Course Management data grid, you could use "Begins With" to filter the Course ID column on all Course IDs beginning with the value of "SCI." Records that would return include SCI101, SCI02, SCI200, SCI300, etc. because the Course IDs begin with the provided value of "SCI." A Course ID that starts with "COMPSCI" would be excluded because it begins with "COMP."
- Example: If you want to see all science courses in the Course Management data grid, you could use "Begins With" to filter the Course ID column on all Course IDs beginning with the value of "SCI." Records that would return include SCI101, SCI02, SCI200, SCI300, etc. because the Course IDs begin with the provided value of "SCI." A Course ID that starts with "COMPSCI" would be excluded because it begins with "COMP."
- Ends With – Filter to include only records that end with the provided value. In this case the "provided value" you type must be the exact content used in the end of the value entry.
- Example: If you want to see all entry level courses in the Course Management data grid, you could use "Ends With" to filter the Course ID column on all Course IDs ending with the value of "101." Records that would return include ENG101, MATH101, SCI101, PHYS101, etc., these IDs end with the provided value of "101."
- Example: If you want to see all entry level courses in the Course Management data grid, you could use "Ends With" to filter the Course ID column on all Course IDs ending with the value of "101." Records that would return include ENG101, MATH101, SCI101, PHYS101, etc., these IDs end with the provided value of "101."
- Contains – Filter to include only records that contain the provided value. In this case the "provided value" you type must be a word, phrase, or character(s) used in the value entry.
- Example: If you wanted to see all students in the Student Management data grid with an allergy, you could use the "Contains" filter on the Medical Alerts column with the value of "allerg" so that it will display all student records with the terms "allergies, allergy, and allergic" in the Medical Alert column.
- Example: If you wanted to see all students in the Student Management data grid with an allergy, you could use the "Contains" filter on the Medical Alerts column with the value of "allerg" so that it will display all student records with the terms "allergies, allergy, and allergic" in the Medical Alert column.
- Does Not Contain – Filter to include only records that do not contain the provided value. In this case the "provided value" you type must be a word, phrase, or character(s) that is missing in the value entry.
- Example: If you wanted to see all students who do not have an email address in the system, you could use the "Does Not Contain" filter on the Email Address column with the value of "@" so that it will only show records that do not have "@." In this column. Since "@" is required in all email addresses, you will only see student records that do not have email addresses.
Checkbox Filter
The Following Checkbox Filter can be applied to various columns within SchoolFront that have previously defined options. In the filter explanations below you will see one example of the checkbox filter in SchoolFront.
Note: Columns default to “Show All” if a filter is not applied, displaying all records.
- Clear Filter - Choose the "Clear Filter" option to clear any filter that you configured and show all records. This is useful if you create a filter and then do not need it anymore and want to see all records or if you create a filter and it does not yield the record(s) you desired and you want to start over with all records.
- Include Empties in List- Filter to include empties in the column.
- Exclude Empties in List- Filter to exclude empties in the column.
- Include Selected- Filter to include your selection within the column.
- Exclude Selected- Filter to exclude your selections within the column.
- Unselect All- Click to deselect any options that you have previously selected in the list.
- Select All- Click to select all options within the list to populate within the column.
*Note: various options will populate within list depending the column you are filtering on.