...
Table of Contents |
---|
For the video links below, it is recommended that you first open another tab in your browser, log into Infinite Campus, then go to the Campus Community BEFORE clicking on the links below. If you have never logged in to the Campus Community, you can find instructions here.
Filter Types
There are three different ways to create ad-hoc filters in Infinite Campus:
Query Wizard
This is the most commonly used tool for creating filters.
For a list of Ad Hoc fields, check out this link in the Campus Community: https://kb.infinitecampus.com/help/student-filter-fields-for-ad-hoc-reporting
Selection Editor
This tool can be used for manually selecting specific students to include in your filter
https://kb.infinitecampus.com/help/create-a-static-list-of-students-video
Pass-through SQL Query
This method allows you to be very specific by utilizing Structured Query Language (SQL) to query the database. This tool is more advanced and requires knowledge of the database and SQL. You can find lots of examples to get you started in the Campus Community.
...
Data Types
There are also three categories of data that you must select from when creating your filter.
Student
This data type is for filters that require specific student information (name, ID#, grade, etc.). Data is pulled from the calendar selected in the Campus Toolbar at the top of the screen.
Census/Staff
This data type is for filters looking for any person in the database (parents/guardians, staff, etc.). Data is pulled from the entire database, not just the calendar selected.
Course/Section
Use this data type if you need to filter on scheduling information like courses, sections, roster size, etc. Data is pulled from the calendar selected in the Campus Toolbar at the top of the screen.
...
Query Wizard
...
Open the Filter Designer, using this path: Index > Ad Hoc Reporting > Filter Designer
Click Filter Type: Query Wizard
Click Data Type: Student
Click Create.
Filter the Data (Optional)
While this is an optional step, it is one of the most powerful tools to ensure that you get the exact data that you need.
Each field you selected shows on a line by itself. You can apply an Operator to that field and corresponding Value to narrow down your results.
In our example, we want to only include students with a birthday in August, and only include students who are Active today.
For birth date, choose IN THE MONTH OF from the operator list, then type in August in the value field
For ActiveToday, select =TRUE
Info |
---|
Note that the drop-list for operators changes depending on the type of data being evaluated. |
If you add operators and values, they are all considered equally when the database is queried. This means that ALL conditions must be true for data to be returned.
In our example, this means that:
Student has a birth date in August AND
Student has an active enrollment today
What if we wanted to narrow this down to specific grade levels?
The Logical Expression box can be used to combine options to get specific data like this.
For example, if we only wanted grades 8 and 9 returned:
Select student.grade = 08 (NOTE: All grade levels are 2 digits in our database)
Add another line by clicking the Add button, and choosing student.grade = 09
In the logical expression box, type in the statement 5 or 7. These are the ID numbers that identify the field you are talking about
If we still want to include the August birthdays and active students in our filter, we need to add these lines to the logical expression as well. It should look something like this: 4 and 6 and (5 or 7). This means that lines 4 and 6 must be true, and either 5 or 7 must also be true
You can click Save & Test at the bottom of the screen to make sure you are still getting the data you expect
Click Next to move to the next screen
...
Grouping and Aggregation (Optional)
The Grouping and Aggregation editor allows users to group fields into sections and report specific aggregates/sub-totals for each section.
...