The Filter command allows you to restrict the data that appears in a column wherever that column appears in the module for your view.

When data is filtered, the funnel icon is highlighted in the title bar of the window or pane. Double-clicking the icon in the title bar will also display the Filter window. Filtering a column in one window affects all windows and panes in the module that also contain the filtered column. The filter remains in effect until removed or changed (logging off or changing modules will not remove the filter). Each user may configure their own filter for a column. Whether a column may be filtered is set in the Data Window tab of the User Control Properties window. In this tab, the upper pane provides a Filterable? check box that, when checked, defines all columns in the table as filterable. If filtering is not currently enabled for a window, do not turn it on without first consulting with AgileAssets software development.

For example, the Filterable? check box should not be selected when the data source is a 'DW_' procedure.

Note: In addition to filters that you set, data records may be automatically filtered to only those records that have a value in an "owner" column that equals the administrative unit you selected when you logged on. This occurs when the Access-regulated? check box in the Data Window tab of the User Control Properties window is selected.

Graph View ("graph down the road") windows are not affected by filters set in Data View or other windows.

For example, filtering the route to one route in a Data View window will not restrict the routes shown in the Graph View window (even though the Route ID column appears in both views). You must set a separate filter to restrict the records displayed in a Graph View window.

Note: Changing the LRS system may cause filter criteria to be cleared if the criteria include location-referencing columns.
  • No labels

Provide Feedback