Numbers

How to use filter operators for facets containing values of number datatype.

If a particular table column is of the number datatype, clicking on the search input within that filter facet will display the list of available operators:

  • min - the column values that are minimum a particular number.

  • max - the column values that are maximum a particular number.

  • between - the column values that are between two numbers.

  • not - the column values are not a particular numeric value.

  • empty - the column values are empty.

  • not empty - the column values are not empty.

Minimum

  • Step 1: Click the search input and then click the "min" operator button.

  • Step 2: Type a number and click "Apply".

  • Step 3: Filter will be applied in the sidebar. Click "x" to clear the filter.

Maximum

  • Step 1: Click the search input and then click the "max" operator button.

  • Step 2: Type a number and click "Apply.

  • Step 3: Filter will be applied in the sidebar. Click the "x" button to clear the filter.

Between

  • Step 1: Click the search input and then click the "between" operator button.

  • Step 2: Type two numbers after the operator. Then click "Apply".

  • Step 3: Filter will be applied in the sidebar. Click the "x" button to clear the filter.

Not

  • Step 1: Click the search input and then click the "not" operator button.

  • Step 2: Type a number and click "Apply".

  • Step 3: Filter will be applied in the sidebar. Click the "x" button to clear the filter.

  • Step 1: Click the search input and then click the "empty" or the "not empty" operator button.

Last updated

© DNAstack. All rights reserved.