Use the Filter Builder

The Filter feature in Roadsoft filters assets for data collection, reports, safety analysis, and strategy evaluation and optimization. Filters are creatable and usable for all point and line layers within Roadsoft. Filter features are not available for polygon or external layers.

Create a New Filter

1.       Select the desired layer.

2.       Select the Filter button from the Map Tool Options.

3.       Select the Filter Builder… button.

·         Select the All Field Groups drop-down menu to select a group of fields.

·         Select the Find field… field to enter a field name to search for.

4.       Select a field from the Field list.

5.       Select an operator from the Operator list.

6.       Select or enter a value from the Value list.

7.       Select the Group field to enter which group the criteria is in.

All criteria are part of Group 1 unless changed. Filters display assets that meet all the criteria in a group, but an asset only needs to meet the criteria of one group to appear. Number groups in whole numbers from one to four.

8.       Select the Add button.

Filters can have multiple criteria added to them.

·         Remove criteria.

a.       Right-click criteria from the list.

b.      Select the Clear Selected Criteria option.

·         Clear all criteria.

a.       Select the Clear button

b.      Select the Yes button to clear all criteria, or select the No button to close the window.

9.       Save the filter.

a.       Select the Save button

b.      Select the Name field to enter a name.

·         Select the Group drop-down menu to add the filter to a group.

·         Select the Description field to enter a description.

·         Select the Shared Filter check box to share the filter with other database users.

c.       Select the Save As button to save the filter, or select the Cancel button to close the window.

·         Select the Apply as Filter button to apply the filter to the map.

·         Select filter assets.

·         Append to Selection – Add filter assets to any currently selected assets.

·         Replace Selection – Replace any currently selected assets with filter assets.

10.   Select the X button to close the Sign Filter Builder window.

Edit a Filter

1.       Select the desired layer.

2.       Select the Filter button from the Map Tool Options.

3.       Select the Filter Builder… option.

4.       Select the Open button.

5.       Select the desired filter name.

6.       Select the Ok button to load the filter, or select the Cancel button to close the window.

7.       Add criteria.

·         Select the All Field Groups drop-down menu to select a field group.

·         Select the Find field… field to enter a field name to search for.

a.       Select a field from the Field list.

b.      Select an operator from the Operator list.

c.       Select the Value field to enter or select a value.

d.      Select the Group field to enter which group the criteria is in.

All criteria are part of Group 1 unless changed. Filters display assets that meet all the criteria in a group, but an asset only needs to meet the criteria of one group to appear. Number groups in whole numbers from one to four.

e.      Select the Add button.

8.       Remove criteria.

a.       Right-click criteria from the list.

b.      Select the Clear Selected Criteria option.

9.       Clear all criteria.

a.       Select the Clear button

b.      Select the Yes button to clear all criteria, or select the No button to close the window.

10.   Select the Save button

11.   Select the Save… option to save over the original filter, or select the Save as New Filter… option to save as a new filter.

·         Select the Name field to enter a name.

Cannot change the name is saving over an existing filter.

·         Select the Group drop-down menu to add the filter to a group.

·         Select the Description field to enter a description.

·         Select the Shared Filter check box to share the filter with other database users.

12.   Select the Save button to save the filter, or select the Cancel button to close the window.

When saving a new filter, the Save button becomes the Save As button.

·         Select the Apply as Filter button to apply the filter to the map.

·         Select filtered assets.

·         Append to Selection – Add filter assets to any currently selected assets.

·         Replace Selection – Replace any currently selected assets with filter assets

13.   Select the X button to close the Sign Filter Builder window.

Delete a Filter

1.       Select the desired layer.

2.       Select the Filter button from the Map Tool Options.

3.       Select the Manage Filters… option.

4.       Select the desired filter name.

5.       Select the Delete button.

6.       Select the Yes button to delete the filter, or select the No button to close the window.

Apply a Saved Filter

1.       Select the desired layer.

2.       Select the Filter button from the Map Features.

3.       Select the Apply Saved Filter… option.

4.       Select the desired filter name.

5.       Select the OK button to apply the filter, or select the Cancel button to close the window.

Roadsoft will only apply one filter to a layer at a time. The newly applied filter replaces any filter already in use.

Clear a Filter from the Map

1.       Select the desired layer.

2.       Select the Filter button from the Map Tool Options.

3.       Select the Clear Filter… option.

Save Selection as a Filter

1.       Select the desired layer.

2.       Select assets from the map.

For help selecting assets from the map, see Use the Selection Tool.

3.       Select the Filter button from the Map Tool Options.

4.       Select the Save Selection as Filter… option.

5.       Select the Name field to enter a name.

·         Select the Group drop-down menu to select a group of filters.

·         Select the Shared Filter check box to share the filter with database other users.

6.       Select the Save button to save the filter, or select the Cancel button to close the window.