Help center

    Start for free    Sign in search

      Get Started Add Content Billing FAQs

      View filters

      Thy Nguyen

      Updated on April 18th, 2023

      Table of Contents

      There are two options for how data can be filtered in Grids:

      • View filters that are saved to a View and applied every time the View is displayed. View filters can contain multiple conditions, including regular expressions.
      • Quick filters that represent a fast and easy way for quick filtering. Column filters can be combined together and can not be saved in a View or Grid. Click here to learn more about Quick filters 

      What are View filters?

      View filters are a great way to control the viewable data available to users. Once a View filter is set, it is applied every time a user accesses that view. 

      You can filter out records from a view according to the filter conditions you set. When a record is filtered out, it is not deleted, it is simply hidden in that view. 

      Click here to learn more about Working With Views.

      Setting a View filter

      What is a filter condition? 

      A filter condition is a rule you set in View filters, this will determine which records are displayed in that particular view. 

      A filter condition consists of three parts: 

      • A field - any column in your Grid
      • An operator - Operators compare the fields in the filter against values you provide. The operators available depend on what you are filtering; text, numbers, dates, etc. 
      • A value - the value that you compare against all of your records in the selected column.

      Filter_condition.png

      Creating a filter condition

      1. Click the mceclip1.png on the toolbar.
      2. Click Add filter.
      3. Select the field (column) you wish to filter.
      4. Select the operators (e.g. contains, is empty, is filled, etc).
      5. Provide a value for the filter condition
      6. (Optional) To add an OR clause, click image2.png to the right of the condition.
      7. (Optional) To add an AND clause, click image1.png  below the clause.

      If Dependencies are set in a Grid, View filters can be used to filter data based on status of the dependencies. To filter data by dependency status, select a column for which a dependency is set, choose the “is” operator, and select a status from the dropdown menu in the Value field:Add_Filter__1_.gif

      Removing a filter condition

      To delete a condition permanently, click image6.png  to the right of the condition.

      image4.gif

      Combining multiple clauses using OR/AND clauses in View filters

      Filter conditions consist of one or more clauses. Multiple clauses can be joined with "OR" logic, "AND" logic, or both.

      OR clause

      OR clause is used if you want to view the records that meet any of the conditions. For example, if you want to view the records that are Out-of-date in French, or the records that are Out-of-date in Italian, use the OR clause.

      image5.png

      AND clause

      AND clause is used if you want to view the records that meet all of the conditions. For example, if you want all the filtered records using the OR logic above but to display must also contain records featuring TRUE in the Legal Approved column, add an AND clause.

      image7.gif

       

      Was this article helpful?


      0 out of 0 found this helpful

      Still need some help?

      Contact Support