Versions Compared

Old Version 1

changes.mady.by.user Margaret Boeneke

Saved on

compared with

New Version Current

changes.mady.by.user Madeline Meehan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space PD and version 7.6

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, a funnel on a yellow background Image Removed appears 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 his or her 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 selected determines whether , when checked, defines all columns in the table may be filteredas 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
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
Note: Changing the LRS system may cause filter criteria to be cleared if the criteria include location-referencing columns.