Ad Astra Apps Advanced Filtering Overview

Melody Quinn

October 28, 2021 22:15

Advanced filtering allows you to build structured queries using a query-like language. To create an advanced filter, click the filter edit mode icon ( ) next to the Quick Filters button. Click into the new Filter bar, and your options will pop up with what you can filter by.

Learn more about field definitions and sharing your filters.

Constructing Queries

The basic syntax for a query consists of a field, followed by an operator, followed by a value. The query can be combined using the AND or OR operator. Values are case insensitive so MATH and math will match equally.

A query that returns matches that contain the subject MATH in Fall Semester 2019 looks like this:

Term = 201908 AND Subject = MATH

A more complex query that returns matches that contain the subject MATH or SCI looks like this:

Subject = MATH OR Subject = SCI

Quotation marks are required for values that contain spaces. A query that returns matches that contain a course title that equals Intro Financial Accounting looks like this:

Title = “Intro Financial Accounting”

Enrollment Ratio is a percentage and can be represented as either a whole number or a percentage when constructing a query. If a decimal is in the query, the number will read as a decimal percentage. Example: EnrollmentRatio = .85 would return Enrollment Ratio equal to .85%

EnrollmentRatio = 80%

EnrollmentRatio = 80

To filter to 120 level courses, you would need to construct the query like this:

CourseNumber starts_with 120

Use "in" to see if a value is in a specific set of values or attributes. To use this operator, quotation must be used with values separated by commas.

Subject in “ENGL, FREN, SPAN”

CourseNumber in “1100, 1101, 1102”

In Monitor on the Analyze tab, when a filter with the ‘AND’ operator is created or loaded the query will treat the ‘AND’ as an ‘OR’. Example: Subject = MATH AND Subject = Eng will be treated as Subject = MATH OR Subject = Eng return both Math and English courses.

Setting The Precedence of Operators

You can also use parenthesis to set the precedence of operators. For example, a query that returns matches that have either MATH or SCI subjects and have less than 2 sections would look like this:

(Subject = MATH OR Subject = SCI) AND SectionsOffered < 2

Supported Operators

Text Fields

Equals	=
Not Equals	!=
Contains	contains
Not Contains	!contains
Value In	in
Starts With	starts_with
Does Not Start With	!starts_with

Numeric Fields

Equals	=
Not Equals	!=
Great Than	>
Greater Than or Equals	>=
Less Than	<
Less Than or Equals	<=

Watch and learn a demonstration of advanced filtering!