A filter is a way to create complex, nested rules based on part properties and is used to group parts that meet the filter criteria. A rule is defined by looking at a part that you want to be included in a filter or report and then identifying unique property values that will result in a filtered grouping. Filters can be used in the Model viewer under Company to filter parts displayed or in defined reports.

Time Saving Note: The STRATUS Customer Success Team has configured and can transfer to your company database Filters, Reports, Task Definitions, Task Workflows, Task Categories, Cost Categories, Cost Types, Tracking Statuses, and other Admin configurations. Contact the STRATUS Service Desk for more information.

Configuration

New Filter

To create a new filter:

On the Admin > Company > Filters page, click the New Filter button. A new row will display highlighted in yellow.
1. Name - The name of the filter.
  1. If the Model Viewer checkbox is checked, the Filter Name will display in the list of Company filters.
  2. If the Model Viewer checkbox is not checked, the Filter Name will display in drop-down lists that filter data.
2. Category - Enter a Category to categorize filters within the Filters dialog. If you want more than one filter in a Category, copy the Category name from one filter and paste into the Category field of the other filter.
3. Model Viewer
  1. If Model Viewer is checked, the Filter Name will display in the list of Company filters.
  2. If Model Viewer is checked and a Category is entered, the filter will display under the Category under Model Viewer > Filters.
  3. If Model Viewer is checked and Category is Empty, the filter will display in the Default Category under Model Viewer > Filters.
  4. If Model Viewer is not checked, the filter will only be available in drop-down lists that filter data like Task Workflows.
  5. If Model Viewer is checked, and if a Category is entered, and if a Grouping is selected, the filter will display under the Category under and the items will be grouped as defined under the Filter. See the Groupings (Admin) article for more information.
Click Save.
Once the filter is saved, expand the filter to add groups and rules.
When adding a Rule, decide whether All (default) rules must be applied to get results, or, if Any of the rules can be applied to get results.
Click the Rule button. A row will display to define the rule.
Click the Property field to select any field from your database. Note: Any model published to your company will populate the fields available in the Property drop-down. You can type or copy/paste the field name to locate it in the list.
Next, select a Rule.
Then, enter a Value. Note: To determine specific values, you can select the part in one of the STRATUS viewers, click the Properties tool, and then lookup the value for the property.
Add more rules as needed.
1. Note: Possible Values will not display unless the Populate Possible Values button is clicked. By design, this feature does not support multiple rule select.
Once done, look for the filter as described above depending on if Models Viewer is checked, a Category was entered, or a Grouping was selected.

Rules Conditions

Most rule conditions are self-explanatory. The case sensitive rules are defined as follows:

Rule conditions that are not case sensitive:

ContainsAnyCase
DoesNotContainAnyCase

Rule conditions that are case sensitive:

Contains
DoesNotContain

Clone (Copy) Filters

To clone a filter:

On the Admin > Filters button, click the clone button associated with the filter you want to clone.
The cloned report will display and will include an incremented number after the name.

Categorize Filters

Categorize and target filters as follows:

Enter a Category name. Then you can sort filters.
You can now target a filter for the Models > Viewer page which will enable you to distinguish model viewer filters from other report filters.
To target a filter for the Models > Viewer page, under Admin > Company > Filters, check the Model Viewer checkbox associated with the filter. This checkbox is checked by default.
On the Models > Viewer page under Filters > Company, you can view filters targeted for this page.

Fabrication Parts Ancillary Filter for Reports

Create a filter on Ancillary Usage to create reports for Connectors, Airturns, Splitters, etc. Filters are only implemented for “Type” and “Usage”.

Usage can be any of the following:

Airturn
Connector
Hanger
Loose
Seam
Splitter
Stiffener

If you want a report that filters for Connector ancillary data you would use the Ancillary. Usage contains “Connector”. This would filter out all the Airturn, Hanger, Splitter information and leave Clips, Corners, Ancillary Material, Gasket for the connectors.

Type can be any of the following:

AirturnTrack
AirturnVane
AncillaryMaterial
Clip
Corner
Fixing
Gasket
Isolator
Sealant
SeamMaterial
SupportRod
TieRod
SupportSeismic
Unknown

If you want a report containing just the Gasket, you can filter on:
Ancillary.Type contains “Gasket”

Videos

04/09/21 CSG Webinar: Advanced Filtering

00:00 Release Notes Review
06:40 Filters vs. Groupings
11:00 Project Data Fixer Filter
13:30 Filters with Model Viewer Checked
16:30 Filter Conditions for Mains and Olets

03/25/2021 CSG Webinar: Leveraging Groupings In Your Filters

00:00 Release Notes Review
05:40 Groupings Are Applied to Filters
07:30 Project Fixer Filters
18:40 Apply Grouping to Filters used in the Models Viewer
20:00 Grouping Examples

STRATUS 05-28-2020 Implementation Webinar - Advanced Filtering (29:50)

02:00 Overview
03:00 Groupings
04:30 Filter Group Conditions and Choosing the Best Filter Property
11:00 Alias for Size
12:00 What Format Is Your Filter Property Stored In?
17:50 Can an Alias be used to combine fields between AutoCAD and Revit? Yes!
19:10 On the Filters page, can you specify the difference between the Grouping column and the Conditions?
21:30 The Grouping "order" does matter
22:45 Use Service Type, Service, and Source, and Product Description for ITM's
24:40 Project Browser Filters
28:30 Deliverable Definitions are based on Filters that automate fabrication package generation

STRATUS 04-18-2019 Implementation Webinar - Filters and Grouping (22:12)

0:30 Filters and Groupings Overview
7:20 Create Filter
15:30 Run Report with Created Filter
16:20 Apply Grouping to Filter
18:55 Hanger and Trapeze Filters

Filters (Admin)