Filter and Sort the Data in a View

You can use conditions in the query to filter the data in a view. For example, you can choose to include only pending interviews. Conditions are similar to the selections you make when you use the Report Selection: dialog from the Reports menu in Anthology Student.

Anthology Student filters the data in Views and grids so that the data displayed is for the campuses (CampusIds) that are associated with your user ID. For example, if your user ID is associated with three campuses, the Views and grids will contain data for those three campuses.

You can sort the data by one or more columns in the query. For example, you can sort tasks by due date, last name, and first name. The sort you specify in the query is the default in the view.

Access Method

Select the Views tile > Explore Views tile > select a View in the Views Explorer window.

Procedure to Filter Data

1. If the query is not already displayed, select the Show Query button.

2. In the Object list, select the object.

3. In the Available Properties list, select the check the boxes for the appropriate properties.

4. Select the icon at the lower left. The type of data that you selected is displayed in the Conditions box. If the property was not already selected for the view, it is also added to Selected Properties box.

5. Complete the Conditions box.

   Column	Action to Take
   And/Or	If you are filtering on more than one item and you want to specify that: All of the above conditions are true, select And. Any condition is true, select Or.
   Operator	The operators are appropriate for the property selected. Select the operator.
   Value	Specify, or in some cases, select the value for the operator. For some operators, Value is not displayed. Strings with alphabetic characters are not case sensitive.
   	If you are filtering on more than one and you want all of the conditions to be met before the next condition, select the check boxes for the conditions you want in the group and select the Group Conditions icon (). An icon is displayed to indicate the group.

6. Repeat steps 1-4 until you have added all the filters.

7. Select the Save button on the toolbar.

Details for Less Common Operators

The table provides descriptions for some less common operators. For example, equals is common while in (; separated) is not.

Type of Value	Operator	Data Displayed in the View
Numeric or date	is null	Has no value for the property
	is not null	Has any value for the property
String (such as a name or address)	contains	Contains the string specified anywhere in the sting (For example, a value of del for the First Name property would display Delta, Madeline, and Fidel.)
	has length	Has only the number of characters that you specify (For example, a value of 5 for the First Name property would display Delta and Fidel.)
	in (; separated)	Contains whole strings specified and separated by the semi colon (For example, Delta; Madeline for the First Name property would display Delta or Madeline.)
	is blank	Has no value for the property
	is not blank	Has any value for the property

Additional Tasks for Conditions

Task	Action to Take
Remove a condition.	Select the X next to the filter in the column heading.
Remove a grouping.	Select the icon that indicates a group.

You cannot filter or sort properties that contain free-form text (such as notes). For example, you cannot filter or sort on: 

• Building.Note
• ClassSectionLesson.Note
• Course.Note
• FundSource.Note
• HighSchool.Note
• HighSchool.DrivingDirections
• Lender.Note
• StudentAward.Note

Procedure to Sort Data in a View

1. If the query is not already displayed, select the Show Query button.

2. In the Selected Properties box, select the column you want to sort.

3. Select the icon at the upper right. Anthology Student adds the column to the Sort Order box and displays the default sort order (Ascending).

4. Repeat steps 1 and 2 until all of the columns are added.

5. If needed, select the property in the Sort Order box and use the following buttons to make modifications.

   Task	Button to Use
   Move a property up the list.
   Move a property down the list.
   Sort in ascending order.
   Sort in descending order.

6. Select the Save button on the toolbar.

Additional Tasks for Sorting

If you need to delete a sort, select the property in the Sort Order box, and Select the X to the right of the box.

You cannot filter or sort properties that contain free-form text (such as notes). For example, you cannot filter or sort on: 

• Building.Note
• ClassSectionLesson.Note
• Course.Note
• FundSource.Note
• HighSchool.Note
• HighSchool.DrivingDirections
• Lender.Note
• StudentAward.Note