Filtering rows using conditions

Filtering rows using conditions 

Filtering is one of the basic features. When a row is filtered out based on a condition, it is not removed. It is hidden from your table. To apply a filter to your Grid(Table), click the filter tool from the toolbar. A filter menu will appear and you can choose the columns to filter by, the filtering rules and values. For example, in a list with tasks, we want to see only 'Task 5' so we create a filter for the 'Name' column, we set the operator to 'Contains' and type 'Task 5' for filtering value.

Basics 

Filtering condition represents a rule you apply that rows must follow to be visible. For example, you only need to focus on rows that meet certain conditions like rows which contain tasks marked as completed. 

Filtering Condition

 A filtering condition consists of three parts: 

•  column - Any column in your table.
•  operator - After selecting a field, choose a filtering operator from the pre-populated dropdown menu. Different filter operators are available depending on the column type. For example, text fields will have filter operators like "contains," "does not contain,", but numeric fields will have filter operators like "greater than" or "less than"; 
•  value - This is the value you compare all of your rows against. 

Removing a filtering condition 

 You can remove a filter condition by clicking on the X icon next to that condition. 

And & Or 

It is possible to logically connect filter conditions using a conjunction. The two conjunctions available are "And" and "Or". You can use "And" when you want all filter conditions to be met. Otherwise, you can use "Or" when you would like any condition to be met.