The Filter Designer allows users to create queries based on filter type (Query Wizard, Selection Editor, Pass-through SQL) and data type (student, census/staff, course section). These queries can be used to generate reports (e.g. a list of actively enrolled students who are 18 or older today) or used to filter to a subset of data elsewhere in Campus (e.g. send a letter to actively enrolled students who are 18 or older today).
See the Filter Designer article to learn how to use this tool.
Filter DesignerIn addition to Ad hoc rights, the user may need R rights assigned to the following areas to allow full access to reporting on Student, Census/Staff or Course/Section filter data types:
- Student Information > General > Summary > GUID
- Student Information > General > Summary > State ID
- Census > People > Demographics > GUID
- Census > People > Demographics > State ID
- SSN Rights
- Scheduling > Courses > Sections > Section
- Scheduling > Courses > Course
Available Tool Rights
Users cannot create or run filters for data elements they do not have tool rights to access outside of Ad hoc Reporting. Rights granted at the top level (Filter Designer) populate to subrights. Deselect subrights as needed for the group you are creating.
Subrights in italics.
| R | W | A | D | |
|---|---|---|---|---|
| Filter Designer |
| Edit existing filters | Add new filters. | Delete filters. |
| Data Warehouse: Allow live data as source | User can select the "live" database option from the Data Source field. | N/A | N/A | N/A |
| Pass-through SQL Filters | View and run existing pass-through SQL filters. | Edit existing filters. | Add new filters. | Delete filters. |
| Query Wizard Filters | View and run existing query wizard filters. | Edit existing filters. | Add new filters. | Delete filters. |
| Selection Editor Filters | View and run existing selection editor filters. | Edit existing filters. | Add new filters. | Delete filters. |
| User Group Filters | View and run existing filters saved in User Groups to which user belongs. | Edit existing filters. | Add new filters. | Delete filters. |
| State Owned Filters | View and run existing State Owned filters. | Edit existing filters. | Add new filters. | Delete filters. |
| Export Filters |
Suggested User Groups
Grant rights to this tool according to your district's needs.
See User Groups and Suggested Roles for more information.
