Create an Ad hoc Filter

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

  • https://kb.infinitecampus.com/help/query-wizard/

• 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.

  • https://kb.infinitecampus.com/help/pass-through-sql-query

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.