Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Revised filter condition formatting

...

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:

Name contains _prompt.EnterName fx

Filter on Current User

If your data contains details of the user, you may be able to filter based on the currently logged in user. For example, to set a filter where the owner equals the current logged in user, add a condition to the filter:

Owner equals _user.name fx

Enter a list of values for an "Is In" or "Is Not In" filter

If you want to select a set of records which have a field set to one of a range of possible values you can do this by selecting the "Is in" or "Is not in" comparator from the drop down list and then simply typing the list of values into the edit box to the right of the comparator as a comma separated list like this:

Country Is in England, France, Germany ABC

Alternatively, you can enter the comparison value as expression:

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

...

  • 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 inwhen the selected condition iis set to I s 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 icon 

Insert excerpt
_filter
picker icon Image Removed
_picker
_filter_picker
nopaneltrue
.

Description tab

FieldDescription
DescriptionDescription of the Filter.

...