Filters
  • 06 Aug 2024
  • 8 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Filters

  • Dark
    Light
  • PDF

Article summary

Filters

Selecting Data (Filter)

While working as the Barchart Editor, Safran Planner provides two features for narrowing down the number of activities presented.

  1. Applying a 'Normal Filter'
  2. Using 'Auto-Filter' on displayed columns

Specifying Activity Selection Criteria

To select a data group, you must specify criteria that are familiar to all the entries in the group. Your selection criteria can be saved as named filters for later reuse. By choosing Filters from the HOME toolbar, you are given a window to select the activities to appear in the Barchart Editor. If no selection criteria are entered, all activities in the project are included.

SP%20BE%20Filters%20Ribbon

Create a new filter

Selection criteria and filter expressions may get complicated and cumbersome to enter, so you may find it helpful to name and store your expressions for future use.

To create a new filter, click on the 'Filters ' icon.

SP%20BE%20Filter%20Icon

Click 'New...'
Planner Filter

Type in a filter name

Planner New Filter

Click 'Insert Row' and add your filter criteria.

Planner New Filter Config

The 'APPLY' and the 'OK' buttons will save any modifications to your filter; the only difference is that 'OK' will close the filter window, while 'APPLY' leaves the window open. If you wish to modify a complex filter, it is recommended to first use the 'Save As...' option so you can go back to the old filter if you are not happy with the new filter.

Remember that a filter could be used in layouts and reports, so changing an existing filter might have consequences you don't see in the current view.

Select a Filter

To select an existing filter, choose from the Filter drop-down list.

Planner Filter Drop Down

The 'Save As...' option allows you to modify and save an existing filter under a new name.

Planner Filter Save As

To remove a filter expression from the list of filters, select the filter from the drop-down box and press the Delete button.

Planner Filter Delete

Keep in mind that filters are 'universal' throughout Safran and may be used in all areas/functions of the system.

When used in a multi-user environment, a filter specified by one user will be available for all users on the system. Other users could choose to modify/adjust the filter ad hoc. However, they would not be allowed to save changes to the original filter. The users would still be allowed to store the filter as their own.

Auto filter

In addition to the filtering capabilities discussed above, Safran also has an 'Auto Filter' tool for the fields nominated in your Barchart layout. To switch the function on/off, select the tool from the Home/Editing portion of the ribbon.

SP%20BE%20Filters%20Autofilter

Or by right-clicking in the Column Header area and toggling 'Auto Filter' as shown below:

Planner AutoFilter DropDown

When an auto filter is turned on, a down arrow appears to the right in each column heading, indicating that auto filter capabilities are available.

SP%20BE%20Filters%20Colum%20Autofilter

You can select relevant values from the column values drop-down in its simplest form. You can also apply an auto filter to multiple columns as required.

When an auto filter for a column is applied, the down arrow and header turn blue.

Planner AutoFilter Checkboxes

NULL means that there are no values in the cell. If you used the standard filter, the filter above would equal the operator 'IS NOT NULL.'

For flag fields, only two options (Yes/No) are available:

SP%20BE%20Filter%20Apply%20Autofilter%20Flag%20field

In a standard filter, the 'Search' field works as the operator 'Contains.'

SP%20BE%20Filter%20Autofilter%20Search

In addition to simple filtering, Safran provides more extensive capabilities similar to the standard functions discussed earlier.

Selecting 'Extended Filter' in the Auto Filter panel opens a standard filter panel, which allows you to specify a more extensive filter expression with relevant operators for the chosen field.

Once an 'Extended Filter' is specified, the existing simple selection is presented in light grey while the 'Extended Filter...' button is highlighted. To return to simple Auto Filter, press the 'Clear Filter' button.

SP%20BE%20Filter%20Extended%20Autofilter

Planner AutoFilter Extended Filter

Filter Operators

OperatorMeaningUsage guideline
=EqualsThis field is valid for a column that contains text, numbers, or dates. Specify a single value or pick a value from the drop-down list. Results include only records where the data in the column matches the value in the filter.
<>Not equalThis field is valid for a column that contains text, numbers, or dates. Specify a single value or pick a value from the drop-down list. Results include only records where the data in the column does not match the value in the filter.
<Less thanThis field is valid for a column that contains numbers or dates. Specify a single value. The results include only records where the data in the column is less than the value in the filter.
>Greater thanValid for a column that contains numbers or dates. Specify a single value. Results include only records where the data in the column is greater than the value in the filter.
<=Less than or equal toValid for a column that contains numbers or dates. Specify a single value or multiple values. Results include only records where the data in the column is less than or the same as the value in the filter.
>=Greater than or equal toValid for a column that contains numbers or dates. Specify a single value or multiple values. Results include only records where the data in the column is greater than or the same as the value in the filter.
IS NULLno valueValid for a column that contains text, numbers, or dates. Do not specify a value. The operator tests only for the absence of data in the column. Results include only records where there is no data in the column.
IS NOT NULLcontains a valueValid for a column that contains text, numbers, or dates. Do not specify a value. The operator tests only for the presence of data in the column. Results include only records where there is data in the column.
Beginsvalue begins withThis field is valid for a column that contains text, numbers, or dates. Specify a single value. The results include only records where the data in the column begins with the value in the filter.
Not Beginsvalue does not begin withThis field is valid for a column that contains text, numbers, or dates. Specify a single value. The results include only records where the data in the column does not begin with the value in the filter.
Containsvalue containsValid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column contains the values in the filter.
Not Containsvalue does not containValid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column does not contain the values in the filter.
Endsvalue ends withThis field is valid for a column that contains text, numbers, or dates. Specify a single value. The results include only records where the data in the column ends with the value in the filter.
Not Endsvalue does not end withThis field is valid for a column that contains text, numbers, or dates. Specify a single value. The results include only records where the data in the column does not end with the value in the filter.
INvalue equals X (or equals y) (or equals n)Valid for a column containing text, numbers, or dates. Specify a single or multiple values (separating values with a comma). Results include only records where the data in the column matches the value(s) in the filter.
Not INvalue does not equal X (nor equals y) (nor equals n)Valid for a column containing text, numbers, or dates. Specify a single or multiple values (separating values with a comma). Results include only records where the data in the column does not match the value(s) in the filter.

These two filters will, for example, give you the same result:

Planner Filter Operator IN

Planner Filter Operator alternative to IN

Depending on the complexity of your filter, you might have to add parenthesis to ensure you get the selection you want.

Planner Filter Operator Parenthisis

Using the 'Move up' / 'Move down' allows you to rearrange your filter. In the example below, the description row was moved up two rows. This filter will not work unless you modify it.

Planner Filter Operator MoveUpDown

Even if you can save the filter without error, you should still check in the Barchart Editor that you have the desired selection before relying upon it in reports.

Activity Search List

The activity search list allows you to create a subset of activities to browse or investigate and still have all activities selected in the Barchart Editor. This will enable you to browse predecessors or successors, follow the logic outside the activities in the search list, and then revert to the search list and use this as your criteria for investigating the schedule.

Applying the selection criteria as a Filter to the Barchart Editor would allow you to see and investigate the activities that match the requirements.

Opening the Search List.

The Activity Search List option is available from the Filter section on the Home tab. Select 'Options' and then 'Activity Search List.'

Planner Activity Search List

The activity Search list window opens by default with all activities in the project. The Activity Search List displays 'Activity ID' and 'Description'. Activities are sorted by Activity ID. The window is resizable and stays on top of the Barchart Editor until closed.

Planner Activity Search List Selection

Navigating

The Activity Search List window is synchronised with the Barchart Editor so that if you select an activity in the Search list, it will be highlighted in the Barchart Editor, or if you choose an activity from the Editor, it will be highlighted in the Search list if it is one of the activities listed in the search list.

  • You can click on any activity in the search List window, and it will highlight the activity in the Barchart Editor.
  • You can use 'Previous On List' to navigate the activity above the selected activity.
  • You can use 'Next On List' to navigate to the activity below the currently selected activity.

Creating Your List - Filtering

You will usually not navigate the Activity Search List with all activities selected for focus. To create a selection of activities, press the Filter button to select previously stored filter expressions that fit your task. Use the filter window to generate an ad-hoc filter or create a new filter to be stored.

Example of filter applied to create a list of activities for Phase= Q - Civil Work - Construction.

Planner Activity Search List Selection Filter


Was this article helpful?

ESC

Eddy AI, facilitating knowledge discovery through conversational intelligence