Example Queries for Custom Views

The following example shows a query used to view data for final grade change reasons.

The following example shows a custom view that uses the Academics > Class Section Meeting Secondary Instructors object to provide details about the instructors assigned to the periods for class sections. It includes which day the instructors is teaching, the start and end dates, the meeting pattern, and meeting length.

Note: If you create a view for class sections, filter the data in the query to the improve performance. For example, you can filter by term.

The following example shows a custom view that uses the Academics > Class Section Registration Relationships object to provide the registration relationships for class sections. It includes: 

• Basic information about the class section (such as the codes, terms, and start and end dates) 

• Information about the registration relationship rule (such as the name of the rule, whether it allows or denies registration, and the conditions specified in the rule)

You can export the view to Excel and PDF. In the exported files, the rule shows on one line.

To make the rule more readable in an Excel file, follow these steps.

1. In the Excel sheet, select Enable Editing.

2. Select the current sheet using the Ctrl + A keys.

3. In the toolbar, select Align Left and Wrap Text.

The rule will be shown on multiple lines with indentation. The numbering for the nested condition groups does not reflect the numbering shown in the interface. You should use the indentation to determine how the groups of conditions are nested.

PDF files cannot be modified.