Understanding AND vs. OR Filter
  • 1 Minute to read
  • Dark
    Light

Understanding AND vs. OR Filter

  • Dark
    Light

Article summary

Many of the grids in SmarterU allow you to search the columns to find specific values. By providing a filter, you can limit the contents of the grid to only those rows that meet your criteria. 

Oftentimes, you can provide two search filters for a column. If you provide two search filters for a column, you'll need to specify how you want the two filters to be evaluated: AND vs OR. 

  • AND returns only those rows that meet both of the filters. For example, if you have filter A and filter B, using AND would return rows that meet both filter A and filter B.
  • OR returns rows that meet either of the filters. For example, if you have filter A and filter B, using OR would return rows that either meet filter A, meet filter B, or meet filter A and filter B. 

Diagram - And vs Or 20220616

For example, suppose we apply two filters to the Course Builder Dashboard's Task column:

  • Contains "exchange"
  • Contains "policy"

 If we use AND to evaluate the two filters, only tasks that have both "exchange" and "policy" in their name are included.

However, if we use OR to evaluate the two filters, users that have either "exchange" or "policy" in their name are included.

Interface gráfica do usuário, Aplicativo  Descrição gerada automaticamente



Was this article helpful?


What's Next