Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Dev-5452 Added Tip about filter picker being hidden, and revised Filter picker section

...

Apply the filter without saving it.

Image Removed

Insert excerpt
_save
_save
nopaneltrue

Save without closing.

Image Removed

Insert excerpt
_finish
_finish
nopaneltrue

Save and close.

Filter tab

...

Build a filter by adding conditions and clauses.

...

Insert excerpt
_add
_add
nopaneltrue

Add a clause to the filter. Hover over the editor to the right of a condition to see this button.

Image Removed

Insert excerpt
_delete
_delete
nopaneltrue

Delete the selected clause or condition from the filter. Hover over the editor to the right of a condition or clause to see this button.

The value entered is a literal value. Click this icon to change this, if you want to use an expression.

The value entered is an expression. Click this icon to change this, if you want to enter a literal value.

Ignore Case

The condition matches values ignoring case e.g. "abc" would match "abc", "Abc", "ABC", etc.

The default setting is defined on the underlying Stream Attribute.

Image Removed

Insert excerpt
_filter_picker
_filter_picker
nopaneltrue

Display the Filter Pickerfilter picker. Click this icon to display a list of possible values to filter by. See Below for more information. See Filter, below.

Create prompt filter

You can create a filter that will prompt users to enter a value, and filter based on that. For example, if you have data which contains people's names, you could create a filter like:

...

Country Is in ["England","France","Germany"] fx

Using Filter

...

Pickers

If the stream view that you are filtering on has the "allow filter picker" enabled, then you will see Allow Filter Picker selected, then PhixFlow displays the  icon after the value field. Clicking on it will To use a filter picker:

  1. Click on the filter picker icon Image Added to display a list of the possible values to filter on for that field

...

  1. .
  2. Click to select one value, or Shift+click or Ctrl+click to select multiple values to use in the filter
  3. Click on the tick in the bottom right to finish.
    Alternatively double-click on a row to add that row to your selection and close.

To clear the currently selected values, click on the cross in the bottom left.

When you are constructing a quick filter then , the values displayed will be in the filter picker list have already been filtered by any stream view:

  • background filters

...

  • stream view filters

...

  • any other filter conditions

...

  • .

When you select:

  • one value

...

  • from the list, the filter condition

...

  • changes to:
    • either Equals
    • or not Equals, when the selected condition is not Equals
  • multiple values from the list, the value field is automatically changed to an expression,

...

  • and the

...

  • filter condition changes to:
    • either Is in
    • or Is not in, when the selected condition iis set to Is not in.
Tip

There are some scenarios where  PhixFlow cannot generate the list of values for a filter picker list.

  • pivot views
  • where the underlying stream data is aggregated.

In these cases, PhixFlow automatically hides the filter picker icon Image Added.

Description tab

FieldDescription
DescriptionDescription of the Filter.

...