Pricefx Classic UI is no longer supported. It has been replaced by Pricefx Unity UI.

 

Simple Filter

To apply a simple filter, enter a value in the area above the table header. When using Chrome or Internet Explorer, the filter must be activated manually by pressing Enter, when using Firefox the filtering is started automatically. The filter is not case sensitive and also works on incomplete values. Multiple filters can be combined. 

If there is any type of filtering applied, it is indicated by the icon  next to the section title. Once you remove all filters (either manually or by selecting 'Clear Filter' from the context menu), the icon is no longer shown.

There is a wide range of operators available: you can either type them (see the syntax 99685500) or use the pop-up menu available after right-clicking in the filter field:

The only way to clear a filter set up with this pop-up menu is to switch to the default option (listed at the top). 


You can also filter the column on the Matrix icon – whether it is present or not. To do so, use the 'is null' or 'is not null' operator.

Any filter setting can be saved using Preferences  Manager from the drop-down menu.

Filter Expressions

You can type these expressions in the filter field to refine your filtering. (There is no need to remember this syntax – these options are also available in a pop-up menu, as shown above.)

Expression

Meaning

<

less than

>

greater than

<=

less than or equal

>=

greater than or equal

==exact string (use if the filter searches for substring by default)

!

not equal to

~contains (use if the filter searches for exact match by default)
!~does not contain (strings only)

^

starts with (strings only)

|

ends with (strings only)

!^

does not start with (strings only)

#

is null

!#

is not null

Found an issue in documentation? Write to us.