thumb_up
thumb_down
link
Copy link
Copied
insert_emoticon
lmatfy
Copied

Use a quick filter

The quick filter is a simple filter that will give the desired result in most situations. You enter the quick filter in the view and can easily change it.

The quick filter is not case sensitive. If you click in the quick filter, you can use F12 to view a Help window with information about filter options.

In InSite the quick filter is available in all web sections with a table layout, meaning views with columns.

Note:

When opening a view, a filter can be applied automatically. This can cause the view to display less data than you expected.

You can tell whether a filter has been applied by looking at the filter button:

Contents

Quick filter

Every view has a filter bar. You filter a particular column by entering the filter value in the filter bar.

Quick filter on one value:

  1. Open the view:.
  2. Click in the quick filter of the column to be filtered.
  3. Enter the filter value.
  4. Press: Enter.

    Profit shows all lines containing the search value, regardless of case.

    Note:

    In Profit Windows you clear the quick filter using Ctrl+L.

Multiple values

When you search for multiple values, you have two options:

  • OR filter: field must meet one of the filter criteria.
  • AND filter: field must meet all filter criteria.

Quick filter on multiple values (OR filter):

  1. Specify multiple search values, separated by a ; (semicolon).
  2. Press: Enter.

    Profit shows all lines containing the search value, regardless of case.

Quick filter on multiple values (AND filter):

  1. Put a # in front of the search values.

    Snelfilter (20) - En-filter

Does not contain

You filter the lines in which a certain value is not present.

Does not contain:

  1. Enter a ! in the quick filter, followed by the search criterion.
  2. Press: Enter.

    Profit shows the lines that do not contain the value.

    Profit_Snelfilter (30)

Begins with / ends with

You filter the lines in which a field starts or ends with a certain value.

Starts with:

  1. Enter a @, followed by the filter criterion.
  2. Press: Enter.

Ends with:

  1. Enter the character &, followed by the filter criterion.
  2. Press: Enter.

From...to

You filter on a range of values.

From/To:

To specify 'From.. to', you enter .. (2 points).

  1. Press: Enter.

    Profit shows names starting with an A or a B.

Empty field

You filter on fields that do not have a value or on fields that do have a value.

To filter on fields that do not have a value:

  1. Enter: [ ] (opening and closing square bracket).
  2. Press: Enter.

    Profit shows the lines on which this data element has not been recorded.

    Dat_Snelfilter (55)

To filter on fields that do have a value:

  1. Enter ![ ].
  2. Press: Enter.

    Dat_Snelfilter (55)

Multiple fields

If you apply a filter to multiple fields, Profit always applies the AND-filter: Profit will only show lines that meet all criteria. For an OR filter, use an advanced filter.

Quick filter on multiple fields:

  1. Enter filter values in the columns.
  2. Press: Enter.

    Dat_Snelfilter (57)

Copy a field value to a quick filter

You will copy a value from a view to the quick filter.

To copy a field value to a filter:

  1. Open the view:.
  2. Select the value.
  3. Press: (Ctrl+Plus).

    This places the selected value in the quick filter.

    If you press (Ctrl+Minus), the filter is reversed, meaning records containing the selected value are excluded. For example, !Jansen means not Jansen.

  4. You can also use:
    1. Right-click on the value.
    2. Run filter / Filter by selected field to copy the value to the quick filter.
    3. Run filter / Everything except selected field to reverse the filter, excluding the records containing the value. For example, !Jansen means not Jansen.

    You see only the lines that meet the specified filter criteria.

  5. Right-click in the view and go to Run filter / No filter (Ctrl+Shift+D).

    This undoes the filtering, but the filter criteria are retained in the quick filter. You can then further refine the filter.

After you have entered a quick filter, you can decide to proceed in the Filter window. Copy the quick filter you entered to the Filter window using Ctrl+Shift+H.

Directly to

  1. Filter data
  2. Quick filter
  3. Simple filter
  4. Advanced filter
  5. Compare columns using a filter
  6. Filter management
  7. Filter variables
  8. Filter criteria
  9. Examples

Process

View data

Work area

profit