Dates

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

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

  • before - the column values that are before a particular date.

  • after - the column values that are after a particular date.

  • between - the column values that are between a date range.

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

  • empty - the column values are empty.

  • not empty - the column values are not empty.

Before

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

  • Step 2: Click the "calendar" icon button and select a date.

  • Step 3: Click "Apply"

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

After

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

  • Step 2: Click the "calendar" icon and select a date. Then click "Apply".

Between

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

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

Not

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

  • Step 2: Click the "calendar" icon and select a date. Then click "Apply".

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

Empty / Not Empty

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

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

Last updated

© DNAstack. All rights reserved.