7.11.1 Filter Dialog

Filter dialog is used to configure filtering expression for a custom report. Streamline is able to build very powerful filtering expressions. You can filter by any column of the All items report and use several options in one filtering statement. You can build compound expressions having up to twelve filtering statements.

You can create custom reports on the Inventory planning, Inter-store optimization, Distribution center, or Report tab. Depending on the tab, the set of columns used in filtering expressions differs.

To open the Filter dialog:

1. Go to one of the mentioned tabs.
2. Click the New filter button found on the left of the All items tab (see figure below).

• The Text field at the top of the dialog is used to name the filter/report. This name will be displayed in the title of the newly created tab (see figure below).

• Lines of controls below the Text field is used to build a filtering expression.

• The Clear button clears the filtering expression.

A filter or filtering expression is built from elementary statements and structural operators. For example:

Here:

• A, B, and C – elementary statements that can be false or true;
• logical operators OR and AND, and brackets “(”, “)” – structural operators that build the structure of the expression.

By-turn, elementary statements follow the syntax:

The figure below shows the mentioned parts in the Filter dialog.

Streamline filters implement three structural operators. Two of them are logical operators AND, OR and the third one – a brackets operator () AND ().

Each line below the Filter name field is used to build an elementary statement. The X button at the end of each line clears the corresponding condition.

Let's consider examples.

The filter shown in the figure below is equivalent to the expression:

OR operator is always applied after AND operator. Consider an example shown in the figure below.

The equivalent statement is:

As you see, Streamline groups statements that will be applied first using indents. Intends here are equivalent to brackets. So, this filter can be also written as:

This is a brackets operator that is used to control the application order of AND and OR operators. For example, in order to write the following expression:

you should build the filter represented in the figure below.

However, the brackets operator can be applied only at one level. It means that nested brackets are not supported currently. For example, you can't build filtering criteria for the following expression:

An elementary statement in Streamline has the following syntax:

For example:

You can use any column of the All items report in each elementary statement. Streamline automatically loads and shows all the available values for the selected column of which you can select the required (see figure below).

Depending on the column type (string or numeric) set of Streamline relational operators differs (see table below).

For string columns, you can give several values in a statement using comma “,”. This will be treated as a logical operator OR. For instance:

If a value contains a comma, use quotation marks ““ to wrap the value. For example:

Next: In Transition Details Dialog

Download PDF