...
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
https://kb.infinitecampus.com/help/create-a-query-for-a-report-video
https://kb.infinitecampus.com/help/create-a-query-for-a-filter-video
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.
...