Table of Contents
Problem Overview
Solution
Related Articles
Problem Overview
You added filters to a page, such as the Section Dashboard, but the applied filter isn’t returning the correct results.
Solution
Overview | Check Capitalization | Check Filtering Logic | Check for Spaces
Overview
There are three filter settings you should look at when this happens:
Capitalization
Filtering logic
Spaces
Check Capitalization
Check to make sure the filtered value has the correct capitalization.
For example, the course name “Bioethics” should be capitalized to return results.
Check Filtering Logic
Issue One - “Contains Active”
One common mistake is to use the filter logic “contains active.”
In this case, all sections with the status “inactive” will be included in the filtered results because “inactive” contains the word “active” (in which case, you could want to change the logic from “contains” to “is” in order to only show active sections).
Issue Two - Using “Less Than” or “Greater Than” with Course Numbers
The Course Number field can include both numbers and letters, which means it is stored as a string and NOT a number. This can lead to confusing results if you use “less than” or “greater than” logic with Course Numbers.
For example, if you set up a filter that said “Where Course Number (is) Less Than 500”, it would exclude course numbers like “99” because it is only comparing the “5” to the “9” and knows that “9” is GREATER THAN “5”. On the flip side, numbers like 33 and 31 would NOT be filtered out, because “3” is less than “5”.
Check for Spaces
Check to make sure that there are no spaces before or after the search term filter. For example, “Bioethics 2 ” has an extra space and will not return results.
Check to make sure that there are no extra spaces in-between words. For example, “Bioethics 2” has an extra space in-between “Bioethics” and “2”.
