Filtering Data
The filter in table editor lets you filter records (rows) in a table based on conditions. These conditions correspond to expressions that compare fields (columns) and their corresponding entries(cells) and will only return the data that is true to that condition.
- Click
- Enter condition in the text
box:
- Start entering the name of the field you want to filter and select the matching one from the autocomplete list.
Operator Description =, IS Equal >,>= Greater than, Greater than or equal <= Less than, Less than or equal <>,!=, IS NOT Not equal AND Displays records if all the conditions are TRUE OR Displays a record if either of the conditions is TRUE BETWEEN Between a range LIKE Search for a pattern (e.g.: similar values between columns) IN To specify multiple possible values for a column NULL Null values - Multiple filters can be applied by using AND and OR operators. Keep in mind to correctly set the operator that you want to execute first, and use parentheses if needed.
- Enter a numeric or string value after the operator.
- Click Apply
- To clear the condition box, click on the drop-down next to Apply and select Clear