https://kb.infinitecampus.com/help/create-a-query-for-a-filter-video
Filter Types
There are three different ways to create hoc filters in Infinite Campus:
Query Wizard
This is the most commonly used tool for creating filters.
Selection Editor
This tool can be used for manually selecting specific students to include in your filter
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.
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.